Joe Sack Fixing Gatekeeper Row Cardinality Estimate Issues The Query Optimiser needs a good estimate of the number of rows likely to be returned by each physical operator... 01 November 2012 18 min read
Dmitri Korotkevitch Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable,... 23 October 2012 20 min read
Grant Fritchey SQL Server Execution Plans, Second Edition, by Grant Fritchey Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how... 16 October 2012 2 min read
Grant Fritchey SQL Server Performance Crib Sheet Grant Fritchey provides an eagle-eye view of effective tools, strategies and techniques for SQL Server performance measurement, tuning and testing.… 31 May 2007 33 min read
