Get logical reads and cpu usage and query detail in sql server

 SELECT      req.session_id     , req.total_elapsed_time AS duration_ms     , req.cpu_time AS cpu_time_ms     , req.total_elapsed_time - req...

Read More

Get logical reads and cpu usage and query detail in sql server

 SELECT      req.session_id     , req.total_elapsed_time AS duration_ms     , req.cpu_time AS cpu_time_ms     , req.total_elapsed_time - req...

Read More

Create a database backup query with dynamic names in sql server

 declare @filenamedbbc varchar(200) set  @filenamedbbc= 'DB' +replace(convert(varchar, getdate(),101),'/','') + repl...

Read More

Get list of table names and with rowscount in sql server

 SELECT TOP 200 (SCHEMA_NAME(A.schema_id) + '.' + A.Name) AS TableName   , SUM(B.rows) AS RecordCount   FROM sys.objects A   INNER J...

Read More

Get table names list and check whether is memory optimized

 SELECT SCHEMA_NAME(Schema_id) SchemaName, name TableName, is_memory_optimized, durability_desc, create_date, modify_date FROM sys.tables GO

Read More