O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

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 31. Some practical issues in table partitioning

Ron Talmage

This chapter covers two practical topics in SQL Server table partitioning:

  • Strategies for creating partition functions
  • Minimizing data movement

Large SQL Server databases can become difficult to manage due to their size. Usually such large databases have only a couple of large tables that account for most of the databases’ size. Table partitioning is a method for making those large tables easier to manage, and in some cases improving query performance against those large tables.

Table partitioning is an involved topic and can quickly become complex; therefore, this chapter is going to have a limited scope. Let’s look at table partitioning from a general point of view, and ...

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