SQL in the Wild » Performance

Archive for the 'Performance' Category

Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009

Posted in Performance, SQL Server, Syndication, T-SQL | 12 Comments »

Catch-all queries

• Thursday, March 19th, 2009

Posted in Performance, SQL Server, Syndication, T-SQL | 52 Comments »

When is a seek actually a scan?

• Thursday, March 5th, 2009

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »

Identifying inaccurate statistics

• Thursday, November 13th, 2008

Posted in Admin, Performance, SQL Server, Syndication | 2 Comments »

What are statistics and why do we need them?

• Tuesday, November 4th, 2008

Posted in Performance, SQL Server | 4 Comments »

Deadlock Graphs

• Tuesday, September 16th, 2008

Posted in Performance, SQL Server | 12 Comments »

Comparing date truncations

• Thursday, September 4th, 2008

Posted in Performance, SQL Server | 5 Comments »

Views or Functions?

• Tuesday, August 12th, 2008

Posted in Performance, SQL Server | 9 Comments »

Parameter sniffing, pt 3

• Thursday, May 22nd, 2008

Posted in Performance, SQL Server | 10 Comments »

Parameter sniffing, pt 2

• Monday, February 25th, 2008

Posted in Performance, SQL Server | 2 Comments »