The Miseducation Of Everyone
Temporary objects are one of those tricky things. You probably know you should be using them for certain things, but which one to use is a constant source of trial, error, and coin-tosses.
In these videos from my training, I’m going to go through the downsides of table variables. There’s one free video from YouTube at the end about when you should use them, too.

More From This Series
Going Further
For youWork With Your Databases the Way I DoVideo course, $250 until December 1, then $500For your teamAI for Database Teams WorkshopOne day, on-site or remote
Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.
Related Posts
- Even If SQL Server Table Variables Were Always In Memory, It Wouldn’t Make Them Better Than Temp Tables
- Software Vendor Mistakes With SQL Server: Wrap Up – For Now!
- Software Vendor Mistakes With SQL Server: Not Enforcing Code Formatting
- Software Vendor Mistakes With SQL Server: Not Enforcing Code Consistency