SQL Server Management Studio 2008 R2

While it's a great idea to include a debugger to step through T-SQL code, it's not very well done. I frequently get a window handle error, and then I either need to reboot client or restart SSMS.

Microsoft - do some QA testing before release cool new features like this. It's tantamount to baiting me!

Sequence tables in SQL Server 2005

Interesting post by Paul White about Sequence Tables in SQL Server.

SQL Server indexing...

There's a series of articles called SQL Server Index Black Ops... and indeed they are!

Posts:

• Index Black Ops Part 1 – Locking and Blocking
• Index Black Ops Part 2 – Page IO Latch, Page Latch
• Index Black Ops Part 3 – Index Usage
• Index Black Ops Part 4 – Index Overhead and Maintenance
• Index Black Ops Part 5 – Page Splits
• Index Black Ops Part 6 – Fill Factor vs. Page Splits

Undocumented optimizer feature in SQL Server 2005/2008

An interesting series of posts has been done by Paul White...

This is the most interesting...