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.
Going Further
If this is the kind of SQL Server stuff you love learning about: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. 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