Sreepathi1987 (7/21/2014)
Easy One. 🙂But i think it is rather unusual, tempdb is completely wiped out whenever the SQL Server service restarts. Yes or No?
Mostly yes.
If there is corruption in tempdb, that corruption will persist after a service restart. At that point, you have to manually drop tempdb files.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events