A year in review, The 21 + 1 best blog posts on SQLBlog
Best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 posts I enjoyed the most. But wait the year is not over yet. Doesn't matter no one will write anything good till next year anyway (prove me wrong and I WILL update this post).
The first post is really from last year, I mean really, who writes a post on '2006-12-31T13:49:00.000' (yes that is ISO8601)? Since I did not see the post until 2007 I have included it in the list. I tried not to include more than 2 or 3 posts per blogger, I would have included all Hugo's NULL posts otherwise. What is with the 21 + 1 title? The +1 one is my post about using bitwise logic, it is the last link
Below is the list, let me know if I missed anything you really enjoyed and Happy New Year
The Beatles versus the StonesHow Many Data Files Should I Create for a User Database?[Editorial] Get rid of the bad apples in IT?NULL - The database's black holePerformance Impact of Procedure Calls without Owner Qualification -- SQL Server 2000Performance Impact of Procedure Calls without Owner QualificationDid You Know? Run a batch multiple timesWant to Control the Procedure Cache?Is statistics over non-indexed columns updated by index rebuild?Xp_cmdshell and permissionsThe Perils of Hyperthreading for SQL Server5 Things every DBA should know like the back of their hand...Filegroups Part I - Dividing Data for PerformanceDid You Know? SP2 does NOT limit the amount of plan cache you can haveSorted views...2008: Initializing Table Data with Row Constructors2008: Row Constructor or Table-Valued ParameterAnti-Patterns and Malpractices, Volume 1: Tumbling Data10 lessons from 35K tpsWhat’s wrong with SELECT * ?Backup compression in SQL Server 2008
This one is mine
Speed Up Performance And Slash Your Table Size By 90% By Using Bitwise Logic
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using RSS