SQLUSA

Microsoft SQL Server 2000 Best Practices

 

How to estimate tempdb space needed for CHECKDB?

 

Execute the following query in Query Analyzer. It only returns estimates without executing the command:

 

DBCC CHECKDB(DatabaseX) with ESTIMATEONLY

 

The World Leader in SQL Server Training
 
SQLUSA.com Home Page