O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Partitioning a table with RANGE RIGHT

As we saw previously, there are two ways to apply partition ranges while performing table partitioning. In this recipe, we will do the same table partitioning that we did in the previous recipe, Partitioning table with RANGE LEFT. However, this time we use the RANGE RIGHT option for our table partitioning.

Getting ready

The following are the prerequisites for this recipe:

  • An instance of SQL Server 2012 Developer or Enterprise Evaluation edition
  • Path C:\SQLData should be available on your machine

How to do it...

Follow the given steps to implement table partitioning with the RANGE RIGHT option:

  1. Start SQL Server Management Studio and connect to SQL Server.
  2. Execute the following T-SQL script to create the Sample_DB ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required