Next Meeting: Tue, Nov 05 2013
Table Partitioning: Secret Weapon for Big Data Pro
Event Type: Online
Online Meeting URL: https://attendee.gotowebinar.com/register/4241147655227225601
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.
John Sterrett is a database administration senior advisor for Dell, directly responsible for several mission-critical databases. Previously, he was a senior DBA focused primarily on performance tuning at a Remote DBA service company with over 200 SQL Server clients. He has presented at many community events, including PASS Summit, SQLRally, 24 Hours of PASS, SQLSaturday, and local PASS Chapter and Virtual Chapter meetings. He is a PASS Regional Mentor for the South Central US region, co-founded the West Virginia SQL Server User Group, and hosted the first and second SQLSaturday in West Virginia. He is a syndicated blogger at SQLServerPedia and SQLServerCentral.com and a writer for MSSQLTips.com.
UTC : Tue, Nov 05 2013 19:00 - 20:00
Event Time : Tue, Nov 05 2013 14:00 - 15:00 (GMT-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Nov 05 2013 19:00 - 20:00