Table Partitioning: Secret Weapon for Big Data Problems
For demo code and more go to https://johnsterrett.com/presentation...
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.
Watch video Table Partitioning: Secret Weapon for Big Data Problems online without registration, duration hours minute second in high quality. This video was added by user Procure SQL LLC 29 June 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 806 once and liked it 3 people.