SQL in the Wild » Syndication

Archive for the 'Syndication' Category

Full backups, the log chain and the COPY_ONLY option.

• Tuesday, March 8th, 2011

Posted in Admin, SQL Server, Syndication | 12 Comments »

And now for a completely inappropriate use of SQL Server

• Tuesday, February 22nd, 2011

Posted in Artificial Intelligence, SQL Server, Syndication | 4 Comments »

Are int joins faster than string joins?

• Tuesday, February 15th, 2011

Posted in Performance, SQL Server, Syndication | 20 Comments »

Quest Webcast: Dos and Don’ts of Database corruption

• Monday, February 14th, 2011

Posted in Corruption, SQL Server, Syndication | No Comments »

Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

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

Upcoming presentations

• Friday, January 28th, 2011

Posted in Community, Syndication | No Comments »

Distincting an IN subquery

• Tuesday, January 18th, 2011

Posted in Performance, SQL Server, Syndication | 7 Comments »

Capturing the Execution Plan

• Tuesday, January 4th, 2011

Posted in Execution Plans, SQL Server, Syndication | 9 Comments »

Do IF statements cause recompiles?

• Tuesday, December 14th, 2010

Posted in Execution Plans, SQL Server, Syndication | 2 Comments »

Recompiles

• Thursday, November 18th, 2010

Posted in Execution Plans, SQL Server, Syndication | 2 Comments »