Audit on SQL Examples

 SELECT

tbl.name
,ius.last_user_update
,ius.user_updates
,ius.last_user_seek
,ius.last_user_scan
,ius.last_user_lookup
,ius.user_seeks
,ius.user_scans
,ius.user_lookups
FROM
sys.dm_db_index_usage_stats ius INNER JOIN
sys.tables tbl ON (tbl.OBJECT_ID = ius.OBJECT_ID)
WHERE ius.database_id = DB_ID()

Comments

Post a Comment

Popular posts from this blog

Time Example

 SELECT distinct td.[CandidateID] ,pc.Description AS Province ,Year(td.Start) ,Day(td.Start) ,cast(td.[Start] as time) [time] ,cast(td.[End] as time) [time]   FROM [hjklhj].[dbo].[TimesheetDetail] AS td      INNER JOIN [jkljkh].[dbo].[Candidate] AS cd on td.CandidateID = cd.CandidateID   INNER JOIN [hjlhhhj].[dbo].[Province] AS pc on cd.ProvinceID = pc.Id   WHERE pc.Description = 'CB070000-CPT'    AND Year(Start) = '2021'   AND Month(Start) = '01'
Read more

SET IDENTITY_INSERT

Image
  SET IDENTITY_INSERT (Transact-SQL) Article 01/30/2021 2 minutes to read 14 contributors Applies to:   SQL Server (all supported versions)  Azure SQL Database  Azure SQL Managed Instance  Azure Synapse Analytics Allows explicit values to be inserted into the identity column of a table.   Transact-SQL Syntax Conventions Syntax syntaxsql SET IDENTITY _ INSERT [ [ database_name . ] schema_name . ] table_name { ON | OFF }
Read more