Do you find you have tables and indexes that have grown really large? Are you moving around a lot more data than you used to? Are your windows for jobs and maintenance getting tighter? If you answered yes to any of these questions, partitioning may be for you!
Partitioning allows us to break a table or index down into smaller more manageable chunks. Partitioning can enable us to perform maintenance on just part of a table or index. We can even move data in and out of tables with quick and easy metadata only operations.
In this episode, we’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, how to identify if a table is ready for partitioning, and what you need to know about your applications before you implement partitioning.
Check out the show notes at http://sqldatapartners.com/2015/11/10/partitioning/
Episode 237: Getting Started with Power BI - Part 1
Episode 236: Database Monitoring with SQL Sentry
Episode 235: SQL Trail 2021 In-person Q&A
Episode 234: Communication Tips for the IT Pro
Episode 233: ScriptDOM
Episode 232: Giving Technical Presentations
Episode 231: Mental Health and Wellness in IT
Episode 230: RTO & RPO
Episode 229: Data Migration Assistant
Episode 228: Predicting Application Problems with Database Metrics
Episode 227: SSDT Methodologies for DB DevOps
Episode 226: SQL Server IaaS Agent Extension
Episode 225: Dashboard Design Principles
Episode 224: The Standup Meeting
Episode 223: Podcast Update
Episode 222: Azure Arc-enabled Data Services
Episode 221: SQL Trail March 2021 Retrospective
Episode 220: Microsoft Ignite Recap
Episode 219: SQL Server Inventory
Episode 218: File Growths
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Elliot in the Morning