Categories
SQL Server

Implementing Table Partitioning

A little while back we looked at an introduction to table partitioning where we covered the concepts involved in the partitioning. This time out we’ll look at how to implement those concepts to create a partitioned table. As we’re going through the motions for this let’s start off by creating a table and fill it with some […]

Categories
SQL Server

Introduction to Partitioning

In SQL Server you can use partitioning to split a table into multiple segments based on the data contained within it. This feature can be used to bring improvements to performance and provide more flexibility with maintenance for those tables which are partitioned. The impact of these will be key for large data sets where […]