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/

Avsnitt(287)

Episode 15 Working at a University

Episode 15 Working at a University

Corporate culture is a BIG deal when it comes to job satisfaction, and it is interesting to see how different sectors can be.  Today we talk with Doug Purnell, DBA at Elon College in North Carolina an...

28 Okt 201525min

Episode 14: SQL Server Clustering

Episode 14: SQL Server Clustering

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach ha...

21 Okt 201523min

Episode 13 Apply Yourself

Episode 13 Apply Yourself

I attended Kevin Feasel's SQLSaturday session entitled Apply Yourself and thought it was pretty funny. While not close friends, I have know Kevin for a while and knew he had good stuff. He there sha...

14 Okt 201530min

Episode 12: Database Corruption

Episode 12: Database Corruption

Database corruption is something that will eventually come to all data professionals.  While I have been fortunate to only come across is a handful of times, I was glad that I was able to get back the...

7 Okt 201531min

Episode 11: SQL Server Statistics

Episode 11: SQL Server Statistics

So it turns out an old dog can learn new tricks--or at least that is what happened to me when I chatted with Grant Fritchey from Red Gate software about SQL Server Statistics.  Always taking an opport...

30 Sep 201534min

Episode 10: Test Anxiety and Test Preparation

Episode 10: Test Anxiety and Test Preparation

We mix things up a bit as I chat with Thomas Frank from collegeinfogeek.com about test anxiety and test preparation.  Taking a test can be a big deal and it is always interesting to get other options ...

23 Sep 201532min

Episode 09: Database Automation

Episode 09: Database Automation

Joey D'Antoni has been doing quite a bit with database automation and I caught with him to discuss his experiences about how database automation has helped him be more efficient and have fewer support...

16 Sep 201529min

Episode 08: Database Design

Episode 08: Database Design

I chat will Louis Davidson about database design and get his thoughts on some strategies about how to go about making your design and what tools are available to help you.  It may surprise you that, a...

9 Sep 201533min

Populärt inom Utbildning

rss-bara-en-till-om-missbruk-medberoende-2
historiepodden-se
det-skaver
alska-oss
harrisons-dramatiska-historia
nu-blir-det-historia
not-fanny-anymore
johannes-hansen-podcast
roda-vita-rosen
sektledare
allt-du-velat-veta
rss-viktmedicinpodden
i-vantan-pa-katastrofen
sa-in-i-sjalen
rss-max-tant-med-max-villman
rss-sjalsligt-avkladd
rss-basta-livet
rss-om-vi-ska-vara-arliga
sex-pa-riktigt-med-marika-smith
rss-pa-insidan-med-bjorn-rudman