Unique Indexes with GROUP BY

• Post author:Rob Farley
• Post published:November 9, 2008
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingUnique Indexes with GROUP BY

JOIN simplification in SQL Server

• Post author:Rob Farley
• Post published:November 9, 2008
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingJOIN simplification in SQL Server

A few changes…

• Post author:Rob Farley
• Post published:October 30, 2008
• Post category:Uncategorized
• Post comments:2 Comments

Continue ReadingA few changes…

Missing Index in SQL Server 2008 – should try harder!

• Post author:Rob Farley
• Post published:October 12, 2008
• Post category:Uncategorized
• Post comments:12 Comments

Continue ReadingMissing Index in SQL Server 2008 – should try harder!

Doing the maths to understand SQL optimiser choices

• Post author:Rob Farley
• Post published:October 12, 2008
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingDoing the maths to understand SQL optimiser choices

Presenting at ADNUG this week

• Post author:Rob Farley
• Post published:October 6, 2008
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingPresenting at ADNUG this week

Congratulations, Mitch

• Post author:Rob Farley
• Post published:October 6, 2008
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingCongratulations, Mitch

OUTPUT clause – knowing what goes in, and what you’ve accidentally taken out

• Post author:Rob Farley
• Post published:October 4, 2008
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingOUTPUT clause – knowing what goes in, and what you’ve accidentally taken out

Accelerated SQL Server 2008 – Walters, Coles, Ferracchiati, Rae & Farmer

• Post author:Rob Farley
• Post published:September 21, 2008
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingAccelerated SQL Server 2008 – Walters, Coles, Ferracchiati, Rae & Farmer

Improving Your T-SQL Arsenal – slides

• Post author:Rob Farley
• Post published:September 18, 2008
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingImproving Your T-SQL Arsenal – slides