Answer / Sandeep Kumar Mishra

"The TRUNCATE command in SQL Server is used to remove all rows from a table quickly, while consuming fewer system resources compared to DELETE. It works by deleting all records from the specified table and reinitializing its identity column. However, it does not release any locks on the table and does not log individual deleted rows; this makes it faster but also means that it cannot be rolled back like a regular DELETE statement."

Explain about the return statement?

1 Answers  

---

What do you mean by flat file database?

1 Answers  

---

What is Weak Entity set?

1 Answers  

---

What are the three levels of database architecture?

1 Answers  

---

Why fastload support to empty table?

1 Answers   CTS,

---

What is app tier?

1 Answers  

---

Explain about the implementation of business logic in stored procedures?

1 Answers  

---

What do data architects do?

1 Answers  

---

What is a view? How it is related to data independence?

1 Answers  

---

What is 2NF?

1 Answers  

---

What is system catalog or catalog relation? How is better known as?

1 Answers  

---

What is the difference between cube operator and roll up operator? : sql server architect

1 Answers  

---