2008 R2

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

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 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

SQL 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 north to one located in South Florida. The challenges: 1. The locations are disconnected and far from eachother 2. We are going up 3 releases. From 2000 to 2008 R2 (8.0 to 10.5) 3. We […]

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