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 182: XEvents

Episode 182: XEvents

The very first podcast episode I recorded was about Extended Events. We've had several new versions of SQL Server since that time, so I thought it was time to bring up the subject again. We are joined...

21 Marras 201938min

Episode 181: Paginated Reports in Power BI

Episode 181: Paginated Reports in Power BI

In the second quarter of 2019, it was announced that Power BI would support paginated reports--at first this was assumed to be connected to an announcement that Power BI would support the RDL files fr...

13 Marras 201920min

Episode 180: PolyBase in SQL Server 2019

Episode 180: PolyBase in SQL Server 2019

This week we heard the news of the release for SQL Server 2019 and a major focus of this release is data virtualization. In this episode, we discuss PolyBase--a topic we covered in Episode 95; however...

6 Marras 201937min

Episode 179: SQL Trail Recap & Buying Power BI

Episode 179: SQL Trail Recap & Buying Power BI

SQL Trail continues to be an experiment in the making and year three proved no different. Eugene joined us this year and we discuss some of the changes, how the vision has changed for the conference a...

24 Loka 201925min

Episode 178: Database Design

Episode 178: Database Design

After 170 episodes, we bring back Louis Davidson to talk about database design and get his thoughts on how we can get better at planning for our data. The show notes for today's episode can be found a...

17 Loka 201947min

Episode 177: Lock Pages in Memory

Episode 177: Lock Pages in Memory

The Lock Pages in Memory policy came up in our internal discussions. I wanted to chat about it a bit more and I couldn't think of a better person than Rick Lowe. After our recent SQL Trail, we sit dow...

9 Loka 201921min

Episode 176: Power BI Storage Options

Episode 176: Power BI Storage Options

Creating reports in Power BI is awesome, but once you are ready to publish the reports--where are you going to store all the data? In this episode, we discuss storage options for Power BI and discuss ...

25 Syys 201919min

Episode 175: Migrating to the Cloud

Episode 175: Migrating to the Cloud

Are you in the cloud? Lots of folks are talking about moving to the cloud; however, as we find in today's episode this can be tricky to quantify what people mean by being "in the cloud". We are happy ...

18 Syys 201930min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
psykopodiaa-podcast
voi-hyvin-meditaatiot-2
rss-niinku-asia-on
kesken
rss-liian-kuuma-peruna
rss-narsisti
adhd-podi
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-duodecim-lehti
rss-psykalab
aamukahvilla
aloita-meditaatio
psykologia
rahapuhetta
rss-elamankoulu
rss-valo-minussa-2
rss-arkijarki
rss-honest-talk-with-laurrenna
rss-mental-race