Monthly Archives: November 2007

Useful Tricks for Finding Missing and Bad Indexes in SQL Server 2005

Posted on November 29, 2007 by Glenn Berry

As I have written before, having proper indexes in place to support your workload is extremely critical with SQL Server 2005 (as it is with any relational database). Generally speaking, you will want more indexes with a reporting or DSS … Continue reading →

Posted in SQL Server 2005 | 72 Comments

Windows Server 2008 Network Performance Improvements

Posted on November 27, 2007 by Glenn Berry

Ward Ralston has a post outlining some of the improvements in the network stack of Windows Server 2008 compared to previous versions. He talks about a 45x improvement in file transfer time to copy a 10.7GB file from one data … Continue reading →

Posted in Windows Server 2008 | 2 Comments

SQL Server 2008 November CTP Available

Posted on November 19, 2007 by Glenn Berry

Microsoft has released the November CTP of SQL Server 2008. This version has SQL Server backup compression and Intellisense in SQL Server Management Studio among other things. SQL Server 2008 backup compression typically compresses at about a 5 to 1 … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Dell PowerEdge R900 Server Details

Posted on November 16, 2007 by Glenn Berry

Dell has finally released some details about their new, four-socket R900 server that will support the new Xeon 7300 series quad-core CPU. This new box has 32 DIMM slots, so it can hold up to 128GB of RAM. The fastest … Continue reading →

Posted in Computer Hardware | 20 Comments

Windows Server 2008 Features and License Limits Revealed

Posted on November 13, 2007 by Glenn Berry

Microsoft has more detailed information published about the different SKUs of Windows Server 2008 that was announced at TechEd IT Forum in Barcelona this week. An interesting point is that they have raised the license limits on Windows Server 2008 … Continue reading →

Posted in Windows Server 2008 | 5 Comments

Sixteen New Penryn Chips Released

Posted on November 12, 2007 by Glenn Berry

Intel has a press release detailing the sixteen new Penryn based CPUs that were released today. One of the sixteen is the high-end QX9650 quad-core desktop chip, while the other fifteen are server based Xeon chips. Twelve of the Xeon chips … Continue reading →

Posted in Computer Hardware | 4 Comments

Infinite Solutions with Mark Erickson

Posted on November 10, 2007 by Glenn Berry

This site has a nice collection spoof tutorials on how to do things like speed your mail delivery, extend your WiFi range, recharge dead batteries, etc. They are quite well done, and I can’t wait to send some of them … Continue reading →

Posted in Entertainment | Leave a comment

How to Determine the Number of Reads and Writes to a Table in SQL Server 2005

Posted on November 8, 2007 by Glenn Berry

Here are a few more useful DMV queries that will give you a better idea which tables in your database are getting the most read and write activity. You need to have VIEW SERVER STATE permission to access the sys.dm_db_index_usage_stats … Continue reading →

Posted in SQL Server 2005 | 4 Comments

AMD X4 Phenom and Intel Penryn Quad-Core Pricing

Posted on November 7, 2007 by Glenn Berry

Tom’s Guide Daily has a story detailing pricing information for AMD’s upcoming X4 Phenom quad-core, desktop processor. They also talk about pricing for Intel’s soon to debut quad-core Penryn line (which is supposed to launch on Nov 12, 2007) According … Continue reading →

Posted in Computer Hardware | Leave a comment

A Roadmap of Emerging Microsoft Technology

Posted on November 7, 2007 by Glenn Berry

Microsoft’s Jim Cirone (who is an Architect Evangelist with their DPE group), has written up a nice roadmap to some emerging Microsoft developer oriented technology and tools. One mistake I did see was his release date of Q1 2008 for … Continue reading →

Posted in Microsoft | Leave a comment