Answer Posted / mohammed

Guys, Please remember TRUNCATE CAN BE ROLLED BACK.

DELETE TABLE is a logged operation, so the deletion of each
row gets logged in the transaction log, which makes it slow.

TRUNCATE TABLE also deletes all the rows in a table, but it
won't log the deletion of each row, instead it logs the
De-allocation of the data pages of the table, which makes it
faster.

Because TRUNCATE TABLE is not logged, it cannot activate a
trigger.
TRUNCATE can not be Rolled back using logs.
TRUNCATE is DDL Command.
TRUNCATE Resets identity of the table.

DELETE
DELETE removes rows one at a time and records an entry in
the transaction log for each deleted row.
If you want to retain the identity counter, use DELETE
instead. If you want to remove table definition and its
data, use the DROP TABLE statement.
DELETE Can be used with or without a WHERE clause
DELETE Activates Triggers.
DELETE Can be Rolled back using logs.
DELETE is DML Command.
DELETE does not reset identity of the table.

What is the function of sql server agent windows service?

539

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

597

---

How can delete duplicate records in cte in sql server?

524

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

539

---

How to set database to be read_only in ms sql server?

552

---

---

What are different types of views?

557

---

What is difference between clustered and non clustered index?

535

---

When would you use it?

585

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

574

---

What protocol does sql server use?

521

---

What is the difference between dataadapter and datareader?

543

---

How to download and install microsoft sql server management studio express?

565

---

What is auditing in sql server?

505

---

Can you move the resources after pausing the node? : sql server database administration

596

---

What is the filtered index?

563

---