Monday, August 16, 2010

MSSQL delete and truncate table

It is interesting to note that delete all from table is different to truncate the table. You will notice that the table size (view table properties) does not change and it takes longer to do the process. Truncate table is very much quicker and always reduce the size of the table to 0MB.

No comments:

Post a Comment