Monthly Archives: November 2008

Energy Savings For a Desktop Computer

I had an existing gaming PC that I built from parts about a year ago. It was based on an ASUS P5N-E SLI motherboard (which uses a NVIDIA nForce 650i chipset), with an Intel Core 2 Duo E8400 CPU. This … Continue reading

Posted in Computer Hardware | 1 Comment

Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows Server 2008

Microsoft has a new whitepaper up on MSDN that shows some pretty dramatic performance gains when you use transactional replication between geographically distant Publishers and Subscribers with Windows Server 2008 and SQL Server 2008.  Both the Publisher and Subscriber must … Continue reading

Posted in SQL Server 2008 | 2 Comments

Intel X5560 Xeon System Benchmarked

TechRadar got access to a dual-socket, Nehalem EP system (with two 2.8 GHz Nehalem CPUs and 24GB of DDR3 memory), and did some quick benchmarks. They showed some pretty incredible results (almost double the performance of a 3.4GHz, dual socket … Continue reading

Posted in Computer Hardware | 6 Comments

Cumulative Update 2 For SQL Server 2008 Available

Microsoft has released CU2 for SQL Server 2008 RTM.  It is Build 1779. This KB article shows the builds that have been released since RTM. You should get an e-mail from Microsoft with the download link and password almost instantaneously … Continue reading

Posted in SQL Server 2008 | Leave a comment

Intel Core i7 Lust

The long awaited Intel Core i7 processor went on sale on November 16, both at NewEgg and MicroCenter. As is often the case, MicroCenter beats NewEgg’s price. MicroCenter has a small selection of processors, and they often are out of … Continue reading

Posted in Computer Hardware | Leave a comment

Intel Core i7 (Nehalem) Almost Here

Engadget has a post up showing a screenshot of where NewEgg had pricing information up for the upcoming Intel Core i7 processors, which are due to go on sale on November 17, 2008. They include the 2.66GHz 920 for $320, … Continue reading

Posted in Computer Hardware | Leave a comment

SQL Server 2008 Covering Index Question For MCIS-4423

I have had a couple of questions about Assignment 6, so here is an explanation of the answer. Just to refresh our memory, here was the assignment: Imagine you have the following query that is performing poorly: SELECT e.EmployeeID, e.ManagerID, … Continue reading

Posted in SQL Server 2008 | Leave a comment