Select from following answers:- EXEC sp_MSForEachTable 'DELETE FROM ?'
- DELETE FROM <TABLE> WITH NO LOGGING
- DELETE FROM <TABLE> WHERE PRIMARY_KEY IS NOT NULL
- TRUNCATE TABLE

- All Above
TRUNCATE TABLE is fastest since it deletes every row but does not maintain a log for that in the transaction log
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator