Compañeros, you know good care and feeding of your indexes is
VITAL to a healthy database. In this episode of the SQL Data
Partners Podcast, I talk to Sean McCown about the best practices
for index maintenance and how those guidelines are now part of his
The show notes for today's episode are available at http://sqldatapartners.com/2016/04/26/indexmaintenance
In this episode of the SQL Data Partners Podcast I chat with Jason Brimhall, about SQL Server compression and his experience with it. He also answers your compression questions: Why is it a bad idea to compress everything in your database and how does compression work?
You can check out the show notes for today's episode at http://sqldatapartners.com/2016/04/20/compression/. Have a good week and I'll see you on the SQL trail.
Today on the SQL Trail I talk with Richie Rump, the podcaster, blogger, and now new hire at Brent Ozar. He and I discuss measuring query performance, using SET STATISTICS, and the story behind his Statistics Parser application. He also talks about navigating the space between developer and DBA.
The show notes for today's episode are at http://sqldatapartners.com/2016/04/02/statisticsparser/
Compañeros! You heard rumblings about how awesome SQL Server 2016 is, right? I talk with Rick Heiges about the wins he's seen for his clients using SQL Server 2016, including how one client's move from a large Oracle rack to SQL Server garnered them huge improvements in query performance.
Show notes for today's episode are available at http://sqldatapartners.com/2016/04/02/sqlserver2016/