SQL SERVER – 2005 Improvements in TempDB | Journey to SQL Authority with Pinal Dave

Following are some important improvements in tempdb in SQL Server 2005 over SQL Server 2000 Input/Output traffic to TempDB is reduced as logging is improved. In SQL Server 2005 TempDB does not log "after value" everytime. E.g. For INSERT it does not log after value on log as that will be any way logged in… Continue Reading...

Source: SQL SERVER – 2005 Improvements in TempDB | Journey to SQL Authority with Pinal Dave