Monthly Archives: September 2006

Important note about indexes in SQL Server 2005

Based on the number of Google hits that I am getting about my previous post regarding an error like this: Msg 2552, Level 16, State 2, Line 1The index "PK_FeedRecommendations" (partition 1) on table "FeedRecommendations" cannot be reorganized because page … Continue reading

Posted in SQL Server 2005 | 7 Comments

The Death of Habeus Corpus?

Nick Bradbury has a good post about the terrible travesty of a law passed by the U.S. Senate yesterday. When I was growing up and when I served in the Marine Corps during the Reagan Administration, there was never any … Continue reading

Posted in News and politics | Leave a comment

Great American Beer Festival in Denver

A group of people from NewsGator are going to the Great American Beer Festival at the Colorado Convention Center in downtown Denver tonight. One of my co-workers went last night and gave everyone a glowing review this morning. We can … Continue reading

Posted in NewsGator | 1 Comment

More Good SQLOS DMV Info From Slava Ok

Microsoft’s Slava Ok has another good blog post that has some good DMV queries on how to measure CPU pressure, IO pressure, and whether NUMA is enabled in SQL Server 2005. In my daily experience, I find the query shown … Continue reading

Posted in SQL Server 2005 | 5 Comments

More SQL Server 2005 Deadlock Troubleshooting

Bart Duncan has another great post on SQL Server 2005 deadlock troubleshooting. This is really good stuff!

Posted in SQL Server 2005 | 13 Comments

Index Reorganization Error in SQL Server 2005

If you ever see an error like this: Msg 2552, Level 16, State 2, Line 1The index "PK_FeedRecommendations" (partition 1) on table "FeedRecommendations" cannot be reorganized because page level locking is disabled. when you try to run an ALTER INDEX … Continue reading

Posted in SQL Server 2005 | 7 Comments

The Beauty of TABLESAMPLE in SQL Server 2005

If you find yourself needing to “browse” a large table to get a feel for what kind of data is actually in there, there are two common methods for doing it. The first query grabs the top 1 percent, ordered … Continue reading

Posted in SQL Server 2005 | 7 Comments