Jeff Moden - Tuesday, January 9, 2018 4:56 PM

Siten0308 - Tuesday, January 9, 2018 8:47 AM

cool big thanks, this helps a lot, now to tell a So called Senior DBA that it doesnt use tempdb 😛

thanks again

Careful, now.  The head you hand someone may be your own. 😉

There is nothing in the links that Sue posted that proves what she said (although I'm sure she's absolutely correct but I have no actual proof myself) and you can't actually tell someone that they're wrong when you have no actual proof.

Rather than pissing off your DBA by saying something that you can't prove, ask the DBA for proof that it uses TempDB either in a Microsoft White Paper, Books Online, or by someone's verifiable and repeatable test code from some blog or whatever.  If the DBA can't prove it, then the DBA will hopefully learn a lesson about not saying something so confidently without some form of proof.