Build number cut into parts
Identify build number of your SQL Server cut into parts. You can use it in scripting or in automation use cases. More information about build numbers. This piece of code...
Posts related to SQL Server topics, divided to more subcategories by topic focus
Execution count of stored procedures
Check what stored procedures are loading your SQL Server the most. Nice and simple analytical query to check which stored procedures are running most times. Its like small procedures competition...
Database statistics information
Query information about statistics in current database. You will get nice overview about all statistics and their properties in one table. It is important to keep statistics up to date...
Plan cache distribution per database
Check what database is using most of plan cache. Every query execution requires execution plan. Execution plans are in most cases then stored in plan cache for reuse. This behavior...
Memory usage by memory clerks
Look under hood and check what clerks are using memory. The SQL Server memory manager consists of a three-layer hierarchy. At the bottom of the hierarchy are memory nodes. The...
Memory and page file usage
Check configuration and usage of RAM and page file. Useful as quick overview for memory performance problem entry point. You will see if SQL Server using all memory according to...
Get query completion – detailed
Retrieve information about query completion percent and estimated finish time. This is useful when running big databases restore or some hard DBCC database command. You want to check actual state...
Get query completion – simple
Retrieve information about query completion percent and estimated finish time. This is useful when running big databases restore or some hard DBCC database command. You want to check actual state...
Check if login exists (SQL Server 2000)
Verify if required login exists in SQL Server 2000 instance and affect workflow. This is simple query to system view sys.syslogins. Checking for existence of principal with given name. So...
Check if login exists
Verify if required login exists and affect workflow. This is simple query to catalog view sys.server_principals . Checking for existence of principal with given name. So this is useful in...