One reoccurring SQL Server question that I see: Why is my TempDB database so large and what can I go to reduce the size of TempDB? The answer requires some basic understanding of the internals of ...

I have a SQL 2000 SP4 server and MOM 2005 is reporting that the tempdb database log file is getting to large. Sure enough, it the templog.ldf file is a ...

If your application uses the tempdb database a lot, and causes it to grow larger than its default size, you may want to permanently increase the default size of the tempdb file to a size closer to ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

For SQL Server, this has the obvious use case for storing the tempdb database. However, any other database engine with scratch space that gets recreated on the restart of the engine should ...