When you code and you need to use a temporary object what do you use in SQL Server--temp tables or a table variable? There is plenty of conventional wisdom out there and my guest Wayne Sheffield and I talk about the differences between these two objects. Whether it around performance or coding standards, it seems everyone has an opinion about these objects.

Check out the show notes for today's episode at http://sqldatapartners.com/2016/06/21/sql-server-temp-tables/ and I will see you on the SQL Trail compañeros!