ALZDBA (1/20/2013)

---

it will write tempdb stuff to disk all right, it's just not at checkpoint time, like with regular db.
Why: tempdb is re-created every time SQLServer is started, so there is no need with respect to recovery of db.(which is the need with regular db)

Adi Cohn-120898 (1/20/2013)

---

The automatic checkpoint that SQL Server issues is not the only mechanism that writes the data into the disk. If you issue manual checkpoint command, it will write the TempDB's data to the disk. When Lazywriter writes the data to the disk it will also write the TempDB's data.

Adi

We don't usually do the manul checkpoint command.

SO what else make it to write to disk and cause tempdb space grow?

Thanks