Database Object Comparison Software OpenDBDiff running on X64 Windows

In the past we used the very reliable RedGate software to compare database schemas and create scripts for production push. Not always a copy paste, but a good reference for the DBA team to understand the changes and customize/enhance the scripts. We opted to work with OpenDBDIff but broke once we moved to Windows 7 X64. Now there is a version that seems to be working properly on X64 Windows.

Link: http://opendbiff.codeplex.com/releases/view/51995

Microsoft Says there is nothing wrong with SQL Server 2008 R2

Over 3 weeks ago we solved the issue we were having with one  particular cluster node running SQL Server 2008 R2. We have been going back and forth with Microsoft to obtain an explanation on why the erratic behavior of the RDBMS engine.

Continue reading

Query Performance Issue in SQL Server 2008 R2

We migrated from SQL Server 2005 X86 to SQL Server 2008 R2 X64 a couple of weeks ago. The new hardware has twice as much RAM, much better I/O and CPU power to spare. I have discussed about the first issues we encountered with Hyper-Threading enabled here.

Continue reading

Playing with Page Level Compression and Indexes

Row and Page Compression are features added to SQL Server 2008 and there are plenty of articles/blogs that discuss about it. I had the opportunity to play with a particular table I needed to archive and gathered some statistics while in the process. Continue reading