SQL Server Table Partitioning: Resources

There is a mountain of information out there on partitioning.

SQL Server Table Partitioning Poster

Although there were significant performance improvements introduced in SQL Server 2008, it is still worthwhile to read some of the documentation from SQL Server 2005 first to understand the basic principles. Your SQL Server version is important: read through the KB section to see what’s been fixed!

This is not an exhaustive list and it is not ranked. I put comprehensive and introductory material first, then try to organize the details farther down. I periodically update this list with the latest interesting blog posts I find. Let me know if this is helpful!

–Kendra

Content on BrentOzar.com

Here’s material that we’ve authored on table partitioning here on BrentOzar.com.

Great Starter Material

If you’re new to table partitioning, this section contains a mix of whitepapers and blogs which are a great place to get started.

Videos

Whitepapers

Recent Hotfixes / Connect Items

  • Workaround: Decreased performance for SQL Server when you run a TOP, MAX or MIN aggregating clause on columns other than the partitioning column – KB 2965553  (This is also a Connect Item.)
  • FIX: SQL Server 2008 R2 or SQL Server 2012 takes a long time to generate scripts for a partitioned table that uses the data compression feature. KB 2714634
  • FIX: Insufficient system memory error occurs when you try to create an index in a char, varchar, or nvarchar type column in SQL Server 2012 – KB 2897454  (HT Martin Catherall)
  • FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 (descending non-unique NC index, note that a trace flag is required to make the fix take effect) – KB 2892741
  • FIX: You receive an incorrect result when you run a query against a partitioned table in SQL Server 2008 R2 or in SQL Server 2012 (maxdop > 6) – KB 2770258
  • FIX: Slow performance when an AFTER trigger runs on a partitioned table in SQL Server 2008 R2 or in SQL Server 2012 – KB 2606883
  • Possible slow performance on CheckDB in tables with many partitions on SQL Server 2012 – Connect Item

Blogs

SQL Server Books Online – Partitioning Topics

Print

  • Sql Server MVP Deep Dives: http://www.manning.com/nielsen/
    • Ron Talmage: “Some practical issues in table partitioning”
    • Dan Guzman: “Partitioning for manageability (and maybe performance)”

Tools

css.php