Home Forums SQL Server 2008 SQL Server 2008 - General Truncating 100GB table RE: Truncating 100GB table
Steve Jones - SSC Editor
SSC Guru
Points: 734314
More actions
October 30, 2013 at 11:04 am
#1662800
As Keith mentioned, it will vary, depending on your system. The truncate should be fairly quick, but the logging of the deallocations might take some time and will increase your t-log space needed.