THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

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

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.

  1. 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
  2. Partitioning enhancements in SQL Server 2008
  3. Five Different Ways To Return Data From One Table Which Doesn't Exists In another Table
  4. When GETDATE() is not a constant
  5. SQL Cache Dependencies
  6. Storage Performance for SQL Server
  7. Is the 8KB page obsolete or aging?
  8. Let's deprecate UPDATE FROM!
  9. Geek City: Nonclustered Index Keys
  10. Which to use: "<>" or "!="?
  11. Execution Plan Costs
  12. The Most Important Performance Monitor Counters for SQL Server
  13. SQL Teaser: Some Things Are Not What They Seem
  14. SQL Server Query Processing Puzzle: LIKE vs ?
  15. Performance / Storage Comparisons : MONEY vs. DECIMAL
  16. SQL Server 2008 Page Compression: Using multiple processors
  17. Did You Know? I have a question for you on DBA Blunders!
  18. I have a question for you on DB development blunders!
  19. Triggers...Evil?
  20. Indexing Foreign Keys - should SQL Server do that automatically?
  21. Data modeling: art or science?
  22. Are inserts quicker to heap or clustered tables?
  23. Large Query Performance and Query Parallelism
  24. Large Query Performance from SQL Server 2000 to 2008, 32 & 64-bit
  25. Geek City: Reading the Transaction Log
  26. An open letter to all 3rd-party vendors: DO NOT USE SA ANYWHERE IN YOUR APPLICATION
  27. Defensive database programming: qualifying column names.
  28. Defensive database programming: rewriting queries with NOT IN().
  29. My stored procedure "best practices" checklist
  30. Geek City: When is FULL Recovery not Really FULL Recovery
  31. LINQ to SQL: Does it have much of a future?

Which was your favorite post of the past year?

Published Wednesday, December 31, 2008 11:36 AM by Denis Gobo
Filed under: ,



James Luetkehoelter said:

Woot! I got one on the list! And I was trapped underneath a refrigerator for most of the year!

December 31, 2008 6:26 PM

Jungsun Kim said:

Thank you for good information.

I would post it my blog ^^

January 4, 2009 11:55 PM

Ram said:

Hi Denis, Good Post.

   When GetDate() is not a constant is pointing to the diff. URL.

July 27, 2009 6:13 AM
New Comments to this post are disabled

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog


Privacy Statement