Grant Fritchey Seven T-SQL Performance Anti-Patterns: Wrong Data Types, Non-Sargable WHERE, Multi-Statement UDFs, NOLOCK, Query Hints, RBAR, Nested Views Seven classic T-SQL performance anti-patterns that cause slow queries: wrong data types forcing implicit conversions, functions in ON/WHERE clauses blocking... 31 July 2012 16 min read
Rod Colledge Reliable Storage Systems for SQL Server By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC... 12 May 2010 12 min read
Kathi Kellenberger Writing Efficient SQL: Set-Based Speed Phreakery Phil Factor's SQL Speed Phreak challenge is an event where coders battle to produce the fastest code to solve a... 04 February 2010 31 min read
