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 256: The Community Episode
Episode 255: Automate Complex CRUD with sp_CRUDGen
Episode 254: Code Smell Checks with sp_Develop
Episode 253: Go Mobile with Power Apps
Episode 252: The Cumulative Update Dilemma
Episode 251: Azure Cognitive Services
Episode 250: What happens before... “COMPANEROS!”
Episode 249: Data Marts in Power BI
Episode 248: Inventory Documentation
Episode 247: Pushing the Boundaries or Pushing Your Luck
Episode 246: Microsoft Build 2022 Announcements
Episode 245: Tooling Updates
Episode 244: Extended Events vs SQL Server Audit
Episode 243: Choosing What Content To Focus On
Episode 242: Upgrading Your SQL Server
Episode 241: Replicating Data with Azure SQL Data Sync
Episode 240: Azure Synapse Link
Episode 239: Bi-directional HA/DR to Azure SQL
Episode 238: Getting Started with Power BI - Part 2
Episode 237: Getting Started with Power BI - Part 1
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