Table Partitioning: Secret Weapon for Big Data Problems

Is big data starting to slow you down? Data growth putting your maintenance tasks in danger of not meeting your SLAs? Wish you could archive old data with minimal impact to your tables during the archive process or that you could eliminate most of the data in your tables when you query them? If so, it’s time you consider implementing table partitioning to help with general performance and reduce your window for completing maintenance tasks.

Come learn how table partitioning works and when it should be implemented. You’ll see how to initially configure partition functions and partition schemes to have a rock-solid partitioned table. And you’ll learn how to implement an automated sliding window to maintain your partitioned tables and ensure optimal performance.

***** The demo code, and sample database can be downloaded here.  Please read the ReadMe.txt to replay the demos *****

Video

 

Slides

Reference Material

---

• VIDEOS
  • MCM Table Partitioning
• TOOLS
  • Partition Management Utility v3.0 By Stuart Ozer
• WHITE PAPERS
  • Partitioned Table and Index Strategies Using SQL Server 2008
  • Partitioned Tables and Indexes in SQL Server 2005
• LINKS
  • Creating and Updating Incremental Statistics in SQL 2014
  • Special Guidelines for Partitioned Indexes
  • Partitioned Tables and Indexes
  • Sliding Window Table Partitioning
  • Query Processing Enhancements on Partitioned Tables and Indexes
• BLOGS
  • Partitioning 101 – @SQLFool
  • Using Filtered Statistics with Partitioned Tables – SQL CAT
  • Partitioning & Archiving Table in SQL Server (The Basics)
  • How To Decide if You Should Use Table Partitioning – @Kindra_Little