Monthly Archives: September 2006

Important note about indexes in SQL Server 2005

Posted on September 29, 2006 by Glenn Berry

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?

Posted on September 29, 2006 by Glenn Berry

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

Posted on September 29, 2006 by Glenn Berry

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

Posted on September 29, 2006 by Glenn Berry

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

Posted on September 25, 2006 by Glenn Berry

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

Posted on September 22, 2006 by Glenn Berry

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

Posted on September 19, 2006 by Glenn Berry

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

NewsGator Desktop Sync Beta

Posted on September 19, 2006 by Glenn Berry

Nick Harris did a great job in polishing up and improving the product that was demonstrated at MIX06 back in March, which is now available as the NewsGator Desktop Sync Beta. This application is really very slick.

Posted in Windows Vista | Leave a comment

Update for Data Dude CTP 5

Posted on September 17, 2006 by Glenn Berry

Microsoft released an update for CTP 5 of the Visual Studio 2005 Team Edition for Database Professionals (aka "Data Dude") on Friday. This just a patch that addresses performance issues with schema imports, schema difference operations and project reloads. It … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Microsoft Robotics Studio September 2006 CTP

Posted on September 17, 2006 by Glenn Berry

Microsoft has released a new CTP of the Robotics Studio environment that works as a plug-in for Visual Studio 2005 (including the free Express Edition). Microsoft has the beginnings of a pretty big push into robotics with this product. You … Continue reading →

Posted in Computers and Internet | Leave a comment