O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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 Scenarios

As discussed earlier in this chapter, there are a number of good reasons for using partitioning. This section presents a few scenarios of where and how partitioning can be especially beneficial.

Scenario 1: Partitioning Historical Data

In the first scenario, we will look at how partitioning can benefit systems by partitioning based on historical data. This is probably the most beneficial type of partitioning because most financial systems include data that has a date attached to it. As mentioned earlier in this chapter, I generally do not recommend indexing on date fields.

Probably the most effective method of partitioning a financial database is on date. Not all tables include date fields, but the largest tables (for example, ...

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