For this weeks SQL Data Partners podcast, we followed up on one of the #sqlfamily questions that we usually ask at the end of the podcast. If you could change one thing about SQL Server, what would it be? The list that we came up with was: Default file autogrowth settings Default maintenance plans Shrink database or Auto Shrink NOLOCK Hints …

Podcast Episode 57: the SQL Server Hit List – Our Least Favorite Features Read more »

For more information on Common Table Expessions and performance, take a look at my book at Amazon.com: Common Table Expressions Joes 2 Pros®: A CTE Tutorial on Performance, Stored Procedures, Recursion, Nesting and the use of Multiple CTEs There are many reasons that a Temp Table, Table Variable or Common Table Expression can be a good solution, but there is …

Temp Table vs Table Variable vs CTE and the use of TEMPDB. Read more »