Answer Posted / ameya aloni

TRUNCATE:
1. Faster - does its work in single execution by
deallocating the data pages used by the table and reducing
the resource overhead of logging the deletions, as well as
the number of locks acquired.
2. Is DDL command
3. Removes all data
4. Does not make entries in a LOG file
3. Can't be rolled-back
4. Can't filter using WHERE clause
5. Can't call DML triggers
6. Can't ensure data consistency in case of foreign-key
references
7. Resets the IDENTITY back to the SEED

DELETE:
1. Slower - does its work by deleting rows one at a time,
logging each row in the transaction log, maintaining log
sequence number (LSN) information and consuming more
database resources and locks.
2. Is DML command
3. Removes data row-by-row
4. Makes entry per row in a LOG file
3. Can use COMMIT or ROLLBACK
4. Can filter using WHERE clause
5. Can call DML triggers
6. Ensures data consistency in case of foreign-key references
7. Does not reset the IDENTITY

what are date and time data types? : Sql dba

1026

---

Is sql similar to python?

1034

---

Are dml statements autocommit?

1092

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1112

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1173

---

What are tables and fields?

1084

---

How to select unique records from a table?

1106

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1092

---

What is the execution plan in sql?

1070

---

What is user defined functions?

1028

---

Advantages and disadvantages of stored procedure?

1165

---

what is the syntax used for partition in tsql? : Transact sql

1059

---

Why we use join in sql?

1023

---

What is difference between inner join and cross join?

1016

---

What is difference between mysql and postgresql?

1231

---