How SQL Server processes a query

The logical order in which SQL Server parses a query and generates an execution plan: 1. FROM [left_table] 2. ON [join_condition] 3. [join_type]…

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 –…

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…