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