ChrisM@Work (7/22/2014)
Hugo Kornelis (7/21/2014)Especially for tuning, tempdb is not a good place to try. Various features of the optimzed are not used in tempdb! (I know because I have been bitten by this often enough that I now, finally, remember. Most of the time).
That's interesting, Hugo, and a little scary because I know a few folks here on ssc use tempdb specifically for this purpose. Do you have any documentation yet or is a little early?
I have no documentation. The reason I know this is from experience - things like trying to repro something in my tempdb, not being able to get it, posting in despair to the MVP mailing list, and getting a response from Paul White (who else, when it comes to this subject) pointing out that I should try it in a permanent database instead.
After I think the third time, it now finally sticks. 🙂
If there is any official documentation on this, and if I have ever seen it, I do not remember it. But I can assure you from personal experience that it is true.