Answer / pankaj dhatrak

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

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers   CMS, Impetus,

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

How to create a local temporary stored procedure?

0 Answers  

---

Which virtual table does a trigger use?

8 Answers   TCS,

---

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  

---

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

Explain error handling in ssis?

0 Answers  

---

What are the types of normalization?

0 Answers  

---

How to include text values in sql statements?

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

How to insert data into an existing table?

0 Answers  

---

What are points to remember while using the fillfactor argument?

0 Answers  

---