SQL Server cannot start without TempDB (or master and model) and is massively dependent on it, for a large number of both system and user operations.

I am contributing to the effort of optimizing our SQL 2000 server where I work. The downside is--I'm a novice (but quickly learning) when it comes to SQL 2000 tuning. One of the areas that I want ...

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 ...