Tuning slow spatial queries in SQL Server

• Post author:Rob Farley
• Post published:April 29, 2015
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingTuning slow spatial queries in SQL Server

SHOWPLAN permission denied even if the database isn’t actually used

• Post author:Rob Farley
• Post published:April 14, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingSHOWPLAN permission denied even if the database isn’t actually used

T-SQL v MDX: Pick the hierarchy and populate the report parameter values

• Post author:Rob Farley
• Post published:April 2, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingT-SQL v MDX: Pick the hierarchy and populate the report parameter values

Tuning Parallel Data Warehouse Queries

• Post author:Rob Farley
• Post published:March 10, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingTuning Parallel Data Warehouse Queries

Why isn’t my filtered index being used?

• Post author:Rob Farley
• Post published:February 22, 2015
• Post category:Uncategorized
• Post comments:7 Comments

Continue ReadingWhy isn’t my filtered index being used?

SQL Injection – the golden rule

• Post author:Rob Farley
• Post published:February 10, 2015
• Post category:Uncategorized
• Post comments:6 Comments

Continue ReadingSQL Injection – the golden rule

Medians pre-SQL 2012

• Post author:Rob Farley
• Post published:January 27, 2015
• Post category:Uncategorized
• Post comments:3 Comments

Continue ReadingMedians pre-SQL 2012

APS / PDW Monitoring

• Post author:Rob Farley
• Post published:January 13, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingAPS / PDW Monitoring

Four SQL MVPs at LobsterPot – including three in Australia

• Post author:Rob Farley
• Post published:January 2, 2015
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingFour SQL MVPs at LobsterPot – including three in Australia

Merry Christmas

• Post author:Rob Farley
• Post published:December 24, 2014
• Post category:Uncategorized
• Post comments:1 Comment

Continue ReadingMerry Christmas