Turning a Scan into a Seek With A Pointless Predicate Post author:Rob Farley Post published:May 25, 2011 Post category:Uncategorized Post comments:11 Comments Continue ReadingTurning a Scan into a Seek With A Pointless Predicate
Covering Index because it’s Covering up the truth? Post author:Rob Farley Post published:May 25, 2011 Post category:Uncategorized Post comments:11 Comments Continue ReadingCovering Index because it’s Covering up the truth?
New hires, new site, new location Post author:Rob Farley Post published:May 24, 2011 Post category:Uncategorized Post comments:4 Comments Continue ReadingNew hires, new site, new location
PowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition Post author:Rob Farley Post published:May 24, 2011 Post category:Uncategorized Post comments:21 Comments Continue ReadingPowerShell script to help uninstall SQL Server 2008 R2 Evaluation Edition
Covering, schmuvvering – when a covering index is actually rubbish Post author:Rob Farley Post published:May 19, 2011 Post category:Uncategorized Post comments:22 Comments Continue ReadingCovering, schmuvvering – when a covering index is actually rubbish
New PASS Summit speakers that deserve votes Post author:Rob Farley Post published:May 19, 2011 Post category:Uncategorized Post comments:3 Comments Continue ReadingNew PASS Summit speakers that deserve votes
CTEs – query-scoped views Post author:Rob Farley Post published:May 10, 2011 Post category:Uncategorized Post comments:2 Comments Continue ReadingCTEs – query-scoped views
LobsterPot submissions for SQLPASS Post author:Rob Farley Post published:May 6, 2011 Post category:Uncategorized Post comments:0 Comments Continue ReadingLobsterPot submissions for SQLPASS
The power of T-SQL’s APPLY operator Post author:Rob Farley Post published:April 13, 2011 Post category:Uncategorized Post comments:25 Comments Continue ReadingThe power of T-SQL’s APPLY operator
SELECT and WHERE, but no FROM clause Post author:Rob Farley Post published:April 12, 2011 Post category:Uncategorized Post comments:8 Comments Continue ReadingSELECT and WHERE, but no FROM clause
