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 63: New Data AvailabilityFeatures in SQL Server 2016

Episode 63: New Data AvailabilityFeatures in SQL Server 2016

Availability groups provide both high availability features and disaster recovery options, but they also have several areas you must be aware so you don't introduce more risk into your environment.  T...

28 Syys 201636min

Episode 62: Ask Me Anything--Cortana Intelligence Suite

Episode 62: Ask Me Anything--Cortana Intelligence Suite

Have you heard the buzz around the Cortana Intelligence Suite? It seems like it is all the rage these days and Microsoft is coming out with lots of new features in this space. In Episode 62, Steve and...

21 Syys 201634min

Episode 61: The Debrief

Episode 61: The Debrief

Do you dread the idea of going to the project post-mortem?  Is it because you have to spend tons of time prepping your defenses for the onslaught?  This week we chat with Russ Thomas and get his take ...

14 Syys 201647min

Episode 60: What is U-SQL?

Episode 60: What is U-SQL?

When Microsoft introduced the Azure Data Lake, they included a new language, U-SQL, for Big Data processing as part of the Cortana Intelligence Suite. U-SQL plays a role in the streaming analytics sp...

7 Syys 201639min

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

Episode 59: Mirroring, Availability Groups, Replication, and Log shipping

Have you ever wondered what the best option is for making your data available in your environment? Listener Chris Hendon asked us to talk about differences between Availability groups, mirroring, log ...

31 Elo 201649min

Episode 58: 4 ways to stay sharp with technical learning

Episode 58: 4 ways to stay sharp with technical learning

With all the changes in technology, how do you stay up to date with your technical learning?  This is a question we have been asking our guests the last several episodes and in this episode we, the ho...

24 Elo 201626min

Episode 57: What SQL Server feature would you change?

Episode 57: What SQL Server feature would you change?

Compañeros, in Episode 57 of the SQL Data Partners Podcast we take a page from the SQL Server Radio podcast where they list the 50 worst feature and discuss SQLFamily question 2 about what SQL Server ...

17 Elo 201639min

Episode 56: What is your favorite SQL Server 2016 Feature?

Episode 56: What is your favorite SQL Server 2016 Feature?

I found myself in Columbus Ohio at the SQLSaturday event and thought I'd do a live panel discussion about our Favorite SQL Server 2016 Features--what we are most excited about.   We also discuss the "...

10 Elo 201640min

Suosittua kategoriassa Koulutus

rss-murhan-anatomia
rss-narsisti
voi-hyvin-meditaatiot-2
psykopodiaa-podcast
adhd-podi
rss-rahamania
rss-niinku-asia-on
rss-valo-minussa-2
rss-vapaudu-voimaasi
psykologia
aamukahvilla
kesken
rss-koira-haudattuna
koulu-podcast-2
mielipaivakirja
rss-uskonto-on-tylsaa
rss-tietoinen-yhteys-podcast-2
ilona-rauhala
rss-duodecim-lehti
rss-opi-espanjaa