I too would love to see that if it is not a violation of some copyright.

I remember that index builds and rebuilds have an option to build in TempDB. We had some reports that went nuts and returned whole tables and then filtered down to what was needed. Those intermediate results were too large to stay in memory so SQL Server paged them out to (guess where). After a while the server began again to be responsive but TempDB was enormous. We figured that the fastest way to deal with that was to stop and restart the service. Run the following:SELECT

[name], [create_date]

FROM [sys].[databases]

ORDER BY [create_date] DESC Note that TempDB shows at the top of the list most of the time. Also can serve a a quick way to see when the service was last started.