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/
Epsiode 96 Building Community Tools
Episode 95 Polybase
Episode 94 Qlik Technologies
Episode 93 Making Mistakes
Episode 92 SSDT
Episode 91 DBA Tools
Episode 90 Check DBCC
Episode 89 Lone DBA
Episode 88 SharePoint
Episode 87 Resource Governor
Episode 86 TsqlT
Episode 85 2016 Speedbumps
Episode 84 MVP
Podcast 83 Data Visualizations
Episode 82 Indexes Part 2
Episode 81 Indexes Part 1
Episode 80 Containers
Episode 79 SSIS Catalog
Episode 78: Conversion to 2016
Episode 77: New Reporting Options
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