Monthly Archives: October 2006

Statistics Used By the Query Optimizer in SQL Server 2005

Posted on October 31, 2006 by Glenn Berry

Eric Hansen and Lubor Kollar from Microsoft have a helpful article on TechNet that does a very good job of explaining how statistics work and are how they are used in SQL Server 2005. I previously posted some helpful statistics information … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Be careful if you create indexes with the SSMS GUI

Posted on October 25, 2006 by Glenn Berry

Previously, I wrote about strange behavior I noticed with the SQL Server Management Studio (SSMS) when you create indexes using the GUI (as opposed to running a script). The problem is that page level locking is disabled on the index … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Karl Rove is Terrified

Posted on October 25, 2006 by Glenn Berry

Since there seems to be a pretty good chance that the Republicans will lose control of the House and that they may even lose the Senate on November 7, the Republican Noise Machine has gone into overdrive, with nothing but … Continue reading →

Posted in News and politics | Leave a comment

The Republican Congress in Action

Posted on October 24, 2006 by Glenn Berry

Here are a bunch of informative articles on important Republicans running for Congress: –AZ-Sen: Jon Kyl–AZ-01: Rick Renzi–AZ-05: J.D. Hayworth–CA-04: John Doolittle–CA-11: Richard Pombo–CA-50: Brian Bilbray–CO-04: Marilyn Musgrave–CO-05: Doug Lamborn–CO-07: Rick O’Donnell–CT-04: Christopher Shays–FL-13: Vernon Buchanan–FL-16: Joe Negron–FL-22: Clay Shaw–ID-01: Bill … Continue reading →

Posted in News and politics | Leave a comment

Microsoft Robotics Studio October 2006 CTP

Posted on October 24, 2006 by Glenn Berry

The latest CTP of the Microsoft Robotics Studio has been released. Tandy Trower has more details about the enhancements here. I have a Lego NXT (which I have had not had much time to play with yet), and an iRobot … Continue reading →

Posted in Hobbies | Leave a comment

FeedDemon 2.1 Beta 2a

Posted on October 18, 2006 by Glenn Berry

Nick Bradbury has announced that a new beta for FeedDemon is available. It’s pretty amazing that he could still focus on this after getting t-boned by a hit and run driver recently.

Posted in NewsGator | Leave a comment

New CTP6 for Data Dude is out

Posted on October 18, 2006 by Glenn Berry

Microsoft released yet another CTP for Data Dude, aka Visual Studio 2005 Team Edition for Database Professionals yesterday. I have been running the beta, which came out after CTP5 and the patch for CTP5, with pretty good results.  Hopefully, it … Continue reading →

Posted in SQL Server 2005 | Leave a comment

Will Jericho Improve?

Posted on October 14, 2006 by Glenn Berry

I’ve been watching Jericho on CBS, and so far, I’m am very disappointed.  The basic premise is that Jericho is a small town somewhere in Western Kansas. One day, all communication with the outside world suddenly stops, and the residents … Continue reading →

Posted in Entertainment | Leave a comment

What is an “UPSERT” ?

Posted on October 12, 2006 by Glenn Berry

A pretty frequent pattern I see in queries and stored procedures is where someone does something like this: — Check for existence of row, then UPDATE itIF EXISTS(SELECT * FROM dbo.Customers WHERE CustID = @CustID)    BEGIN        UPDATE dbo.Customers        SET FirstName … Continue reading →

Posted in SQL Server 2005 | 7 Comments

SQL Server 2005 Statistics Primer

Posted on October 9, 2006 by Glenn Berry

If you have a large, active OLTP database, it is extremely important that you keep your statistics up to date. Statistics are critical to the SQL Server query optimizer. Missing or outdated statistics can allow the query optimizer to choose … Continue reading →

Posted in SQL Server 2005 | 14 Comments