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 58: 4 ways to stay sharp with technical learning
Episode 57: What SQL Server feature would you change?
Episode 56: What is your favorite SQL Server 2016 Feature?
Episode 55: The new and improved SQL Server Reporting Services
Episode 54: An Executive Panel Interview
Episode 53: THE Argenis Fernandez interview on storage
Episode 52: Statistics are coming to the DB R you ready?
Episode 51: A PowerShell Story
Episode 50: SQL Server Settings
Epsidode 49: Temp Tables VS Table Variables
Episode 48: Is the Data Warehouse Dead?
Episode 47: Helping Your Data Find A Home
Episode 46: Unraveling Code
Episode 45 Service Broker
Episode 44: Azure SQL Data Warehouse
Episode 43: Why is ETL so hard?
Episode 42: Who made that change? Find out with Auditing
Episode 41: Index Maintenance
Episode 40: SQL Server Compression
Episode 39: Set statistics and StatisticsParser.com
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
Lex Fridman Podcast
The Unbelivable Truth - Series 1 - 26 including specials and pilot