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?