A moving time…

• Post author:Rob Farley
• Post published:February 20, 2010
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingA moving time…

Book Review – oldie but a goodie – Inside SQL 2005 Query Tuning and Optimization

• Post author:Rob Farley
• Post published:February 19, 2010
• Post category:Uncategorized
• Post comments:2 Comments

Continue ReadingBook Review – oldie but a goodie – Inside SQL 2005 Query Tuning and Optimization

T-SQL Tuesday #003 (Relationships): The round-up

• Post author:Rob Farley
• Post published:February 13, 2010
• Post category:Uncategorized
• Post comments:0 Comments

Continue ReadingT-SQL Tuesday #003 (Relationships): The round-up

The Query Optimizer’s handling of Relationships for T-SQL Tuesday #003

• Post author:Rob Farley
• Post published:February 9, 2010
• Post category:Uncategorized
• Post comments:4 Comments

Continue ReadingThe Query Optimizer’s handling of Relationships for T-SQL Tuesday #003

Invitation for T-SQL Tuesday #003: Relationships

• Post author:Rob Farley
• Post published:February 2, 2010
• Post category:Uncategorized
• Post comments:8 Comments

Continue ReadingInvitation for T-SQL Tuesday #003: Relationships

A CASE study in SARGability

• Post author:Rob Farley
• Post published:February 2, 2010
• Post category:Uncategorized
• Post comments:2 Comments

Continue ReadingA CASE study in SARGability

SARGable functions in SQL Server

• Post author:Rob Farley
• Post published:January 22, 2010
• Post category:Uncategorized
• Post comments:7 Comments

Continue ReadingSARGable functions in SQL Server

T-SQL Tuesday – HAVING Puzzle answer

• Post author:Rob Farley
• Post published:January 12, 2010
• Post category:Uncategorized
• Post comments:3 Comments

Continue ReadingT-SQL Tuesday – HAVING Puzzle answer

T-SQL Tuesday – T-SQL Puzzle with HAVING

• Post author:Rob Farley
• Post published:January 12, 2010
• Post category:Uncategorized
• Post comments:3 Comments

Continue ReadingT-SQL Tuesday – T-SQL Puzzle with HAVING

Foreign Keys against Views

• Post author:Rob Farley
• Post published:January 5, 2010
• Post category:Uncategorized
• Post comments:8 Comments

Continue ReadingForeign Keys against Views