Which command is the faster for deleting records from a table (without referential integrity)?

 Posted by Rajnilari2015 on 11/2/2015 | Category: Sql Server Interview questions | Views: 377 | Points: 40
Select from following answers:
  1. EXEC sp_MSForEachTable 'DELETE FROM ?'
  2. DELETE FROM <TABLE> WITH NO LOGGING
  3. DELETE FROM <TABLE> WHERE PRIMARY_KEY IS NOT NULL
  4. TRUNCATE TABLE
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response