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 116: Are people still using PSSDiag?
Episode 115: The Companero Conference Retrospective
Episode 114: How do you start consulting?
Episode 113: Standing on the shoulders of giants
Episode 112: Keeping up with patching
Episode 111: How do you prepare for conferences?
Episode 110 How do I build trust with my team
Episode 109: To certify or not to certify?
Episode 108: The Future of the Relational Database
Episode 107 BI for the Little Guy
Episode 106 Temporal Tables
Episode 105 When is enough, enough?
Episode 104: Keeping up with technology
Episode 103 Plan Reuse
Episode 102 Monitoring Availability Groups
Episode 101 Inspecting a new Database
Episode 100 Role Reversal
Episode 99 Imposter Syndrome
Episode 98: The first change you make
Episode 97 Transactional Replication
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
Lex Fridman Podcast