Just a quick question. Can DBCC Shrinkfile be used to shrink the tempdb and
if so is there anything I should be aware of when using it on tempdb. We had
a process that grew the tempdb to 77 GB. We think we have a handle on the
problem, but I would like to shrink the tempdb without cycling SQL Server.
Thanks.

Yes, dbcc shrinkfile may be used against tempdb. If you have problems
shrinking a large portion (ie, it seems to never finish), shrink in smaller
increments, such as 5gb at a time. However, if the server is not utilized
very heavily, you should be able to shrink to your original tempdb size with
no problem.

Show quoteHide quote

SQL 2000 on W2k fragmentation
Performance: Primary Key = int/nvarchar/guid/...
How do I get my local data in the database on the Internet?
Trusted Connection failing
Why do Ado.net don't use execution plan that Query Analyzer
Switching off logging on varbinary column
Memory allocation in MS-SQL 2000 instances
Windows says SQL is installed, but it's not!
Multiple jobs on one schedule
Query suddenly becomes very slow