Skip to content
Episode 17: Partitioning episode artwork

Nov 11, 2015 25 min

Episode 17: Partitioning

from SQL Data Partners Podcast

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 details come from the podcast's RSS feed.

Embed this episode

Ready to play

Episode 17: Partitioning

0:00 25:35

No transcript yet.

Requests help us decide what to transcribe next.

Share this episode

Similar podcasts

The Course Mentors Podcast The Course Mentors Hey there, future course creator! Ever feel like turning your know-how into an online course is like trying to solve a Rubik's cube blindfolded? Well, grab your headphones because "The Course Mentors Podcast" is here to be your secret weapon! Meet Aimee and Odette (that's us!), your new best friends in the course creation world. We've been in the trenches for over a decade, and for the last five years, we've been rocking the online course space. Now we're here to spill all our secrets in bite-sized, 15-20 minute episodes that'll fit perfectly in your coffee breaks. No fluff, no filler - just real, actionable advice that'll take you from "um, what's a landing page?" to "holy moly, I just hit six figures!". We're talking everything from crafting your course to marketing it like a pro and building a business that'll have you pinching yourself. Whether you're dreaming of ditching the 9-to-5 grind, adding a sweet extra income str

Frequently asked questions

How long is this episode of SQL Data Partners Podcast?

This episode is 25 minutes long.

When was this SQL Data Partners Podcast episode published?

This episode was published on November 11, 2015.

Can I download this SQL Data Partners Podcast episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.