The dynamic management view sys.dm_exec_cached_plans returns information on query plans currently in memory. This information can … sys.dm_exec_cached_plansRead more
Dynamic Management Objects
Dynamic Management Views and Objects
Capturing Blocked Queries
In a previous post, I presented a solution for monitoring and logging long running queries in … Capturing Blocked QueriesRead more
Capturing Long Running Queries
Long running queries in a database may or may not be a problem, depending on the … Capturing Long Running QueriesRead more
Mass editing of SQL Server objects
Ever had the need to replace a piece of code in multiple SQL Server objects (Stored … Mass editing of SQL Server objectsRead more
Logging changes to sys.configurations
Some server wide settings can have major negative impact if they are changed in your SQL … Logging changes to sys.configurationsRead more
List SQL server roles by users
SQL Server roles can be used to give users server wide privileges. The server roles are … List SQL server roles by usersRead more
A replacement for syslogins
The system table sys.syslogins was marked as deprecated in SQL Server 2005, and is included up … A replacement for sysloginsRead more
An alternative to xp_fixeddrives
Want to know the disk space available on your database server from T-SQL? This can be … An alternative to xp_fixeddrivesRead more
sp_describe_first_result_set
The system stored procedure sp_describe_first_result_set was introduced in SQL Server 2012 and it returns meta data … sp_describe_first_result_setRead more