Using truncate then drop pattern to take advantage of minimal logging

In case the minimal logging is enabled, truncating the table then drop it will save the resources on logging.

http://dba.stackexchange.com/questions/4163/why-use-both-truncate-and-drop

Advertisements