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

Chapter 13. Table and Index Partitioning

In this chapter we will cover:

  • Partitioning a table with RANGE LEFT
  • Partitioning a table with RANGE RIGHT
  • Deleting and loading bulk data by splitting, merging, and switching partitions (sliding window)

Introduction

If data in a database table keeps growing and the number of records in a table reaches a count in billions or more, data retrieval and data manipulation operations on such a large table may become difficult. Due to very huge data, even simple INSERT, UPDATE, or DELETE operations can take a long time. Tasks such as deleting certain old data and rebuilding indexes become hard to perform. Managing and maintaining query performance becomes a challenge in this situation.

In the olden days of SQL Server, ...

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