Home Forums SQL Server 7,2000 Performance Tuning TempDB operations faster? RE: TempDB operations faster?
Rodrigo Acosta
SSC-Insane
Points: 21261
More actions
December 30, 2003 at 12:37 pm
#488249
SQL doesn't has to recovery tempdb when restarted, so it doesn't need to log everything in the log file as much as in a user db.
So write operations should be faster.