A year in review, The 31 best blog posts on SQLBlog for 2008

Denis Gobo — Wed, 31 Dec 2008 15:36:00 GMT

Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year

Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments.

A Gift of Script for 2008: Who's Active, What Are They Doing, and Who is Blocked? New version published today here A Gift of Script for 2009: Who is Active, Redux
Partitioning enhancements in SQL Server 2008
Five Different Ways To Return Data From One Table Which Doesn't Exists In another Table
When GETDATE() is not a constant
SQL Cache Dependencies
Storage Performance for SQL Server
Is the 8KB page obsolete or aging?
Let's deprecate UPDATE FROM!
Geek City: Nonclustered Index Keys
Which to use: "<>" or "!="?
Execution Plan Costs
The Most Important Performance Monitor Counters for SQL Server
SQL Teaser: Some Things Are Not What They Seem
SQL Server Query Processing Puzzle: LIKE vs ?
Performance / Storage Comparisons : MONEY vs. DECIMAL
SQL Server 2008 Page Compression: Using multiple processors
Did You Know? I have a question for you on DBA Blunders!
I have a question for you on DB development blunders!
Triggers...Evil?
Indexing Foreign Keys - should SQL Server do that automatically?
Data modeling: art or science?
Are inserts quicker to heap or clustered tables?
Large Query Performance and Query Parallelism
Large Query Performance from SQL Server 2000 to 2008, 32 & 64-bit
Geek City: Reading the Transaction Log
An open letter to all 3rd-party vendors: DO NOT USE SA ANYWHERE IN YOUR APPLICATION
Defensive database programming: qualifying column names.
Defensive database programming: rewriting queries with NOT IN().
My stored procedure "best practices" checklist
Geek City: When is FULL Recovery not Really FULL Recovery
LINQ to SQL: Does it have much of a future?

Which was your favorite post of the past year?

Denis Gobo : list

A year in review, The 31 best blog posts on SQLBlog for 2008