对于一些很大的表,如果要删除数据用Truncate table比Delete效果要好。
TRUNCATE TABLE (Transact-SQL)
Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.
但是Truncate table需要的权限比较高(db_writer权限是不够的),所以比较矛盾。
Permissions