Follow SQL Server blocking_session_id through a blocking chain, identify the head blocker, and choose a safe ending for the wait.
Pre-Aggregating Data for Fast Dashboards
Pre-aggregating data can make dashboards fast through summary tables or indexed views when grain, refresh, and reader consistency are clear.
SQL SERVER – Remove Bookmark Key Lookup – 4 Different Ideas
A bookmark key lookup slows down any query. Here are my four posts on removing it, gathered in one place so you can read them in order.
SQL SERVER – Understanding Table Hints with Examples
What are hints in SQL Server and when should you use them? Understanding table hints with examples, plus a word of caution about overriding the optimizer.
SQL SERVER – 2005 2008 – Backup, Integrity Check and Index Optimization By Ola Hallengren
Ola Hallengren’s free scripts for backup, integrity check and index optimization in SQL Server 2005 and 2008, with notes from Ola on how they work.
SQL SERVER – Removing Key Lookup – Seek Predicate – Predicate – An Interesting Observation Related to Datatypes
Seek Predicate beats Predicate. An observation from a query optimization project on removing key lookup and how datatypes decide which one you get.
SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008
Change Data Capture records changes without triggers or schema changes. Here are my notes on tuning the performance of Change Data Capture in SQL Server 2008.