October 2009 - Posts

• SQL Server Sheep Ticks

  Posted Wednesday, October 28, 2009 12:09 PM | 9 Comments
  
  

  The doggedness with which certain SQL Server "myths" cling to the coat of the SQL Server community is really quite astonishing. They are the proverbial "sheep ticks"; very annoying and incredibly difficult to dislodge. And even when Read More by Tony Davis | 9 Comments | Comment on this post

• The SSRS 2008 Minefield

  Posted Friday, October 16, 2009 1:11 PM | 13 Comments
  
  

  One of the big advances in Microsoft's "2008 platform", with regard to Reporting Services, was that there would be a single, consistent Report Definition Language (RDL) across all the products. This means that reports developed in Report Builder Read More by Tony Davis | 13 Comments | Comment on this post

• Index Fragmentation Anxiety: a Doctor Speaks

  Posted Thursday, October 01, 2009 5:47 PM | 7 Comments
  
  

  Do you suffer from Index Anxiety? Do you lie awake, worrying about whether you are neglecting to defrag your indexes? We’ve all heard the chestnuts: rebuild all indexes that are over 30% fragmented; reorganize those that are between 10-30% fragmented; Read More by Tony Davis | 7 Comments | Comment on this post