Home Forums SQL Server 2005 Administering TempDB Growing MDF RE: TempDB Growing MDF
Hemant.R
Ten Centuries
Points: 1286
More actions
December 13, 2012 at 2:45 am
#1568212
hi ,
tempdb size increases due to several reason .
may be lot of records inserted or updated,
if large amount of data sorting is done.
Someone created index with option sort in tempdb ,
and DBCC checkdb on large size database