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 *****
- WHITE PAPERS
Pingback: Speaking Today at Big Data Virtual Chapter Meeting | JohnSterrett.com
Pingback: Upcoming Presentations | JohnSterrett.com SQL Server Consulting