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, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
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