Episode 17: Partitioning

Episode 17: Partitioning

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/

Jaksot(287)

Episode 135: Seinfeld Episode

Episode 135: Seinfeld Episode

Normally we have one specific topic we focus on each episode.  This episode is a little different. The show notes for today's episode can be found at http://sqldatapartners.com/2018/05/16/episode-135-...

16 Touko 201819min

Episode 134: CosmosDB

Episode 134: CosmosDB

It is not very often the internal codename is used when a product is launched; however, when you think about a database designed with global distribution in mind, CosmosDB makes sense.  I was a bit sh...

9 Touko 201849min

Episode 133: Shrinking Files

Episode 133: Shrinking Files

While the ability to shrink data files is available in SSMS, the conventional wisdom is don't do it.  I was extremely curious when I read an email from our guest suggesting the opposite.  In this epis...

3 Touko 201835min

Episode 132: What technologists can learn from superheroes

Episode 132: What technologists can learn from superheroes

Bang! Pow! Crash!  Besides just awesome fighting techniques, are there things we can learn from superheroes?  My guest, Will Fehringer, gave that very question some thought and came up with some very ...

19 Huhti 201828min

Episode 131: Big Data Solutions in the Cloud

Episode 131: Big Data Solutions in the Cloud

Big Data.  Do you have big data?  What does that even mean?  In this episode I explore some of the concepts of how organizations can manage their data and what questions you might need to ask before y...

11 Huhti 201845min

Episode 130: Use Case for PowerShell

Episode 130: Use Case for PowerShell

Heroes in a half shell, PowerShell!  Well, maybe that wasn't the original line, but you know from this program and other places on the internet, PowerShell is all the rage.  In this episode, we wanted...

4 Huhti 201831min

Episode 129: Graph Databases

Episode 129: Graph Databases

Books online state: "There is nothing a graph database can achieve, which cannot be achieved using a relational database." Why then are we putting graph technology in SQL Server? To help me answer th...

28 Maalis 201832min

Episode 128: Database Doing DevOps

Episode 128: Database Doing DevOps

To Devops or not to Devops, that is the question. We've talked before about how the developers have all the cool new tools, but this is slowly changing. For those in development or dare I say agile ...

21 Maalis 201842min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-narsisti
adhd-podi
psykologia
rss-liian-kuuma-peruna
kesken
rss-niinku-asia-on
rss-duodecim-lehti
ihminen-tavattavissa-tommy-hellsten-instituutti
rahapuhetta
aamukahvilla
rss-honest-talk-with-laurrenna
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
rss-opeklubi
rss-vapaudu-voimaasi
nakokulmia-rikollisuudesta-irrottautumiseen
rss-arkea-ja-aurinkoa-podcast-espanjasta