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

A SQL story in 11 words or less

• Post author:Rob Farley
• Post published:April 5, 2011
• Post category:Uncategorized
• Post comments:5 Comments

Continue ReadingA SQL story in 11 words or less

Function Invertability for SARGability

• Post author:Rob Farley
• Post published:March 24, 2011
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingFunction Invertability for SARGability

Probe Residual when you have a Hash Match – a hidden cost in execution plans

• Post author:Rob Farley
• Post published:March 22, 2011
• Post category:Uncategorized
• Post comments:14 Comments

Continue ReadingProbe Residual when you have a Hash Match – a hidden cost in execution plans