Tag: Table Variables

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

For this weeks SQL Data Partners podcastCarlos Chacon and I 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?

Posted in Podcast Tagged with: , , , , , ,

Temp Table vs Table Variable vs CTE and the use of TEMPDB.

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

Posted in CTE, Performance Tagged with: , , , , , , , ,