Partitions

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

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