sql server

Database
SQL Server

Split a Partition and Expect Locks [SQL Server]

Not in every scenario. But as a rule of thumb, test before you perform a split operation in a production environment.

Read More
Database
SQL Server

Data Compression before or after loading operations? [SQL Server]

Based on what we have experienced, it appears that its more efficient to just immediately insert into a compressed table, with a partitioned clustered index.

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