performance

Database
SQL Server

Migration to 2008 R2. Not as easy as Copy & Paste [Performance]

Better hardware and the latest SQL Server release does not always mean that things will run faster.

Read More
Database
SQL Server

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 More
Database
SQL Server

Incorrect 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 More
Database
SQL Server

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.

Read More