Archives: August 2011
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a compilation of the month long series I wrote in April 2011, called A SQL Server Hardware Nugget A Day, along with additional content from my SQL Server Hardware Read more
After a very long wait, I finally received my new company laptop this past week, which is a very fast Dell Precision M4600. This particular unit has the 2.3GHz Core i7-2820QM quad-core processor, with 8MB of L3 cache. It uses Turbo Boost 2.0 to increase the clock speed to… Read more
As I have said several times before, I am a big fan of data compression in SQL Server 2008 and above. Data compression is an Enterprise Edition only feature that was added to SQL Server 2008, and enhanced with Unicode compression in SQL Server 2008 R2.
It can be very… Read more
Microsoft has released Cumulative Update 9 for SQL Server 2008 R2 RTM, which is Build 10.50.1804.0. I count 26 fixes in this Cumulative Update, which is for the RTM branch of SQL Server 2008 R2. Remember, this is completely separate from SQL Server 2008 SP2, which is the previous… Read more
Microsoft has released SQL Server 2008 R2 SP1 Cumulative Update 2, which is Build 10.50.2772.0. I count 14 fixes in the KB for this Cumulative Update. The most interesting one in my opinion is: FIX: Recovery takes longer than expected for a database in a SQL Server 2008 or… Read more
If you have a situation where you have a very large table in SQL Server, where you need to periodically delete tens of millions of rows of data, there are several ways to do it.
If you have a maintenance window (or your database is not required to be available… Read more
One of the main projects I have been working on lately is designing and implementing a completely new data and storage infrastructure for a high volume, 24×7 online environment. Some of the goals of this effort include improving OLTP performance, improving scalability, reducing the number of SQL Server processor licenses… Read more
Microsoft has released a Product Guide for SQL Server Denali CTP3, which has datasheets, white papers, technical presentations, demonstrations, and links to videos that will help you evaluate Microsoft SQL Server Denali. You can get to Books Online for SQL Server Denali CTP3 here. There is also… Read more
I bought a little Corsair Flash Voyager USB 3.0 16GB USB Flash Drive at Micro Center yesterday, since most of my machines now have USB 3.0 ports. It is also available online from places like New Egg and Amazon
For roughly $25.00 you can hardly go wrong here. One negative… Read more
Two new TPC-E OLTP Benchmark Submissions have shown up in the last month or so since I last recapped three recent submissions back on June 15. The TPC-E benchmark is a very useful comparison and sizing tool for OLTP workloads. Assuming you have enough I/O performance to drive the… Read more
PASS just announced today the next occurrence of 24 Hours of PASS (24HOP), which is called the Summit Preview version. I will be doing a session called Hardware 301: Diving Deeper into Database Hardware at 21:00 (9PM) GMT, which is 5PM Eastern US and 2PM Western US time on… Read more
Since it is August 1, 2011 (which is also my birthday), I thought it would be a good time to unveil a completely new set of Diagnostic queries that focus completely on SQL Server instance level metrics.