SQL Server Page Types Explained

Here is a great blog post explaining the different SQL Server page types and how they work: Understanding Pages and Extents Views –…

Expiring Database Backups

The “Backup set will Expire” option is used to indicate how long a backup should be prevented from being over written by another…

PASS 2015 – Seattle WA – Day 3

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

Display all SQL Server’s Undocumented DBCC Commands

To display SQL Server’s undocumented commands, you can run the following T-SQL:

(use at your own risk, and not on a production…