Monthly Archives: August 2007

Adventures in Home Theater

Back in 2000, when I moved into my new house, I had my family room pre-wired for 5.1 sound, with small in-wall and ceiling speakers, and I bought a Yamaha HTR-5280 AV Receiver. That unit has done yeoman service for casual … Continue reading

Posted in Home Theater | Leave a comment

Cumulative Update 3 For SQL Server 2005 SP2 Released

Microsoft has released Cumulative Update 3 For SQL Server 2005 SP2, which is Build 3186. The Microsoft SQL Server Release Services blog has a post with a link to where you can request the Cumulative Update from Microsoft. The page wants … Continue reading

Posted in SQL Server 2005 | 8 Comments

Interesting Query Optimization in SQL Server 2005

Here is an interesting query optimization problem that I recently encountered on a large production system. The FooBarSubscription table has 32 million rows, while the FooBarInfo table has 1.2 million rows.  The two queries in each batch are identical except … Continue reading

Posted in SQL Server 2005 | 6 Comments

Lock Pages in Memory in 64-bit SQL Server 2005

Microsoft has a good article (KB918483) that explains why it is so important to grant the "Lock Pages in Memory" right to the SQL Server Service Account when you are running 64-bit SQL Server 2005. According to the KB, this only … Continue reading

Posted in SQL Server 2005 | 21 Comments

Cumulative Update 4 For SQL Server 2005 SP2

Microsoft has announced Cumulative Update 4 for SQL Server 2005 SP2 due in "the October 2007" timeframe. This follows Cumulative Update 3 for SQL Server 2005 SP2, which is supposed to be available by the end of August. Technorati Tags: … Continue reading

Posted in SQL Server 2005 | Leave a comment

Amount of RAM For Procedure Cache Should be Configurable

Adam Machanic has a good suggestion up on Connect. Basically, he is asking for a configuration option that would let you set the maximum size of the procedure cache in SQL Server 2005 (and beyond). This is mainly a problem … Continue reading

Posted in SQL Server 2008 | Leave a comment

Windows Vista Updates

James Bannan spent some time digging into a leaked version of an early build of Vista SP1, and has generally good things to say about it. He also mentions two compatibility and performance updates that Microsoft released "under the radar" … Continue reading

Posted in Windows Vista | Leave a comment