Info

SQL Data Partners Podcast

In this podcast, I discuss a variety of SQL Server related topics mixed with a sprinkling of professional development and I talk with some of the biggest names in the industry. I want to introduce new and familiar topics and talk about them in a way you may have not considered. We are all on different stages as data professionals. I hope you will join me on the SQL Trail, compañeros--you won't regret it.
RSS Feed Subscribe in Apple Podcasts
SQL Data Partners Podcast
2019
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: July, 2018

Companeros, welcome to the SQL Data Partners Podcast, a podcast dedicated to SQL Server related topics which is designed to help you become familiar with what’s out there, how you might use features or ideas and how you might apply them in your environments.

Jul 26, 2018

Are you giving yourself a HEAP of trouble by using tables with no clustered indexes?  But it is faster you say . . . because you don't have to worry about the sorting when inserting.  Our guest Rick Lowe suggests everything is fast until you decide to SELECT, UPDATE, or DELETE.  We talk about why you may or may not want to use HEAP tables.  I know I was surprised to get his take on the use of HEAP tables and I think you will be, too. Do you agree with our assessment?  Let us know in the comments on the show notes page.

The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/25/episode-142-do-you-have-a-heap-of-hurting. Have fun on the SQL Trail!

Jul 4, 2018

In this episode, we chat with David Maxwell about wait stats, what they are and why we should care about them. There are so many different directions we can go and if you have a specific use case you’d like us to consider, let us know and we can include it in a future episode.

The show notes for today's episode can be found at http://sqldatapartners.com/2018/07/04/episode-141-wait-wait-what. Have fun on the SQL Trail!

1