Thanks for your time and full test. You do a fine job of myth busting. I've used your reference on SELECT INTO #Temp not actually locking sysobjects in TempDB several times to resolve arguments with DBA's
Thanks Todd... I blew it this time, though
... only disproved half the myth.
I was getting tired and didn't read the whole article that Paul cited... just scanned it. As a result, I missed the fact that it wasn't just about SELECTs. The really cool part of it is that good folks like Paul politely recognize that something was missed and take the time to show what that was... and Paul did it very well and with a great amount of class. Heh... and I love when I learn something new.
Thanks for the reminder on the SELECT/INTO thing. I don't trust much of anything on the Internet (even from Microsoft) so I actually did a full blown test on it. I've been meaning to write an article about all that because it comes up so much but I keep forgetting about it. I've put some reminders on my calendar thanks to your reminder. :-)
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs