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.
Sage advice from the Sage himself.
Heh... maybe not a Sage. Maybe a survivor of such conversations on both ends of that stick. Being wrong in my younger days taught me well.