Answer / pankaj dhatrak

Truncate is more faster
reason truncate direct drop the data page and not save the transactions.

What are the differences between clustered and non-clustered index?

1 Answers  

---

What is a Stored Procedure?

8 Answers  

---

Difference between group by clause and having clause in SQL?

1 Answers   Flextronics,

---

How would you choose between a clustered and a non-clustered index?

1 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1 Answers  

---

How to enable/disable indexes?

1 Answers  

---

Why we use trigger in sql server with example?

1 Answers  

---

How to assign new column names in a view?

1 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

1 Answers  

---

Explain query editor regions

1 Answers  

---

How to write a query with a full outer join in ms sql server?

1 Answers  

---

What is normalization and its forms?

4 Answers   Challenger Financial,

---