Best solution for deleting records

1. What is the fastest way to delete records in T SQL?
2. What are the two ways in which you can DELETE a record?

What is the fastest way to delete records in T SQL?

By far, the fastest way to delete a bunch of records is to use the TRUNCATE TABLE statement. This is much faster than the DELETE statement because it does not log any of the row-level delete operations. However, you can only use TRUNCATE TABLE : To delete ALL the records in the table.

What are the two ways in which you can DELETE a record?

Press DELETE, select Home > Records > Delete, or press Ctrl+Minus Sign (-).