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. Afterward, check out posts on changes made in 2008 to understand the fine print.

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

  • 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: You receive an incorrect result when you run a query against a partitioned table in SQL Server 2008 R2 or in SQL Server 2012 – KB 2770258

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