Table Structure, Trading Maintenance with Performance [SQL Server]
With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
Read moreTag: 2008 R2
MediaWhiz’s BI Solution Goes Live [Analytics]
We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ”This will be the company’s biggest asset”.
Read moreIncorrect Bios Settings Can Reduce Database Performance [SQL Server]
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Read moreSQL Server: Migrating from 2000 EE X86 to 2008 R2 SE X64
Today we had a production migration and brought over one of our legacy applications from a data center located up[…]
Read moreMicrosoft 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[…]
Read morePlaying 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[…]
Read moreSQL Server 2008 R2 and Nehalem Processors
I want to share a note about our latest experiences with SQL Server 2008 R2 EE X64 and Nehalem Processors.[…]
Read more