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...
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...
Gitignore your WordPress project
Are you looking for .gitignore for your Wordpress project? Your are on right place! Git is very popular versioning system. You can use it for cooperating with your teammates or...
Report problem
This page is supposed to be a channel for reporting issues for my customers. If we don't know each other please use form on contact page instead.
[contact-form-7 id="2" title="Problem reporting...
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...