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.
Author Archives: OZ
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.
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
My Home Network
I am an enthusiast and like to play with tech toys whenever possible (usually at night after the kids went to sleep). This time I will write about my home network and how did I set it up. Continue reading
My Entertainment RSS feed bundle
These sites are under of my Google Reader “Entertainment” bundle.