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 159: Power BI Dataflows

Episode 159: Power BI Dataflows

So what happens when you want to use data from two different sources, manipulate it (transform it) and then present the data in Power BI -- and you don't know how to use SSIS? Well, it turns out you c...

6 Helmi 201945min

Episode 158: Gateways

Episode 158: Gateways

For only 10 bucks a month you can start visualizing your data and finally get the dashboard your executives have been waiting for!! What's that? You need to refresh the data--perhaps even multiple tim...

24 Tammi 201935min

Episode 157: Windows Server Core

Episode 157: Windows Server Core

I can still remember working in high school when you had to 'dial in' to the internet and Microsoft bought the rights to the Rolling Stones song 'Start Me Up' for the release of their highly anticipat...

10 Tammi 201933min

Episode 156: Social Intelligence

Episode 156: Social Intelligence

How well do you connect with others? We generally think pretty good of ourselves and at first glance you may give yourself a pretty high score.  While there is no test you can take to compare your res...

2 Tammi 201946min

Episode 155: Data Science

Episode 155: Data Science

Do you want to be a data scientist? Do you even know what data science is? In this episode, we tackle the idea of being a data scientist and discuss the criteria and what it may take to get the job de...

13 Joulu 201840min

Episode 154: Test Driven Development

Episode 154: Test Driven Development

Who hasn't had a deployment go a bit sideways?  For all the talk of DevOps these days, the ability to push out code can still be challenging.  When I heard David Moore, our guest today, talk about the...

21 Marras 201841min

Episode 153: SQL Trail 2018 Retrospective

Episode 153: SQL Trail 2018 Retrospective

Year Two of our beautiful idea--gather together with a group of podcast listeners in a conference type format and find ways for us to connect and help each other grow. I am influenced by what I see i...

7 Marras 201820min

Episode 152: Do you use Analysis Services?

Episode 152: Do you use Analysis Services?

Those trained in SSAS may cringe a bit, but a curious thought entered my mind.  Many organizations start using data warehouse structure with fact and dimension tables, but never make it to the 'cube' ...

1 Marras 201844min

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
psykologia
rss-duodecim-lehti
ihminen-tavattavissa-tommy-hellsten-instituutti
rss-psykalab
aamukahvilla
aloita-meditaatio
rss-honest-talk-with-laurrenna
rss-luonnollinen-synnytys-podcast
rss-tietoinen-yhteys-podcast-2
rahapuhetta
puhutaan-koiraa
rss-elamankoulu