Monthly Archives: January 2009

New Core i7 920 Workstation Goodness

We recently bought a batch of new Dell XPS Studio workstations that have a 2.66GHz Core i7 920 CPU, 6GB of RAM, a 750GB 7200rpm drive, and an ATI Radeon HD 4850 video card.  I took my machine, and put … Continue reading

Posted in Computer Hardware | 18 Comments

Intel Ready to Release Release 3.5GHz E8700 Core2 Duo CPU

DailyTech has a story up about the imminent release of a new, top of the line dual-core CPU from Intel. The nice thing about this is that this will probably cause a price reduction for the existing lower end CPUs … Continue reading

Posted in Computer Hardware | Leave a comment

Understanding Logging and Recovery in SQL Server

Paul Randal is a fellow MVP who worked at Microsoft on the SQL Storage Engine Team for eight years. He does a very good job of explaining how logging and recovery works in SQL Server in this TechNet article. This … Continue reading

Posted in SQL Server 2008 | Leave a comment

Cumulative Update 3 For SQL Server 2008 Available

Right on schedule, Microsoft has released Cumulative Update 3 (CU3) for SQL Server 2008. They have maintained their schedule of releasing a CU every eight weeks since SQL Server 2008 went RTM back in August 2008. The fixes included in … Continue reading

Posted in SQL Server 2008 | Leave a comment

Useful New DMV in SQL Server 2008

There is a new sys.dm_exec_procedure_stats DMV that was added in SQL Server 2008, that lets you get aggregate performance statistics for all cached stored procedures in a particular database. In the sample query below, I do a simple inner join … Continue reading

Posted in SQL Server 2008 | Leave a comment

Denver SQL Server Users Group Report

I attended the monthly meeting at the Denver SQL Server Users Group last night, and listed to a presentation by Steve Jones called “The Modern Resume – Building Your Brand”, which was very interesting. Steve is a fellow SQL MVP, … Continue reading

Posted in SQL Server 2008 | Leave a comment

Revamped SQL Server 2008 Web Site

Microsoft has refreshed their SQL Server 2008 home page, with quite a bit of useful new content. One of the more interesting links is to Learning Resources. There is also a link to a pretty big list of SQL Server … Continue reading

Posted in SQL Server 2008 | Leave a comment