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 NULL: Summer Break

Episode NULL: Summer Break

24 Heinä 20191min

Episode 174: Power BI Report Server

Episode 174: Power BI Report Server

What do you do when you want to use the Visualizations of Power BI but management doesn't want to send company data to the cloud? Well, you can implement Power BI Report Server! In this episode we dis...

27 Kesä 201931min

Episode 173: New Data Certifications

Episode 173: New Data Certifications

As the data platform continues to evolve, so do certifications. In this episode we chat with Rick Heiges about the new role-based certifications and how they fit into Microsoft's cloud platform. We re...

12 Kesä 201936min

Episode 172: Power BI Monitoring

Episode 172: Power BI Monitoring

From a SQL Server perspective we have many ways to identify problem areas. In this episode, we discuss ways to diagnose performance issues in Power BI. They are certainly making many strides; however,...

5 Kesä 201924min

Episode 171: SQL Server Encryption

Episode 171: SQL Server Encryption

You've got first name, last name, full name, birth date, address, email, phone, tax ID or Social Security Number, driver's license number, medical evaluation notes, MAC address, and IP address columns...

22 Touko 201933min

Episode 170: Devops with Power BI

Episode 170: Devops with Power BI

Two years ago blogger Jay Killeen observed, "And with modern languages and modern applications such as PowerBI and Power Query you should be safe to assume there would be modern tooling. You would be ...

15 Touko 201924min

Episode 169: Should you learn to code?

Episode 169: Should you learn to code?

These are dark times. Drastic measures must be taken. In this episode, we talk about--coding. *Queue scary music* Last year I bumped into Sean McCown and found out he had coded himself a GUI for his M...

8 Touko 201943min

Episode 168: Data Privacy Settings

Episode 168: Data Privacy Settings

One of the great abilities we have with Power BI is connecting to multiple data sources. Authors can actually publish data sources for others to use in their reports. Developers then get to mix and ma...

1 Touko 201919min

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