Answer / pankaj dhatrak

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

how we can store the value like that 001,003,023 etc in sql server 2005

7 Answers  

---

What is advantage data architect?

0 Answers  

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

What is a print index?

0 Answers  

---

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

---

Explain a join?

0 Answers  

---

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  

---

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

---

How you can get a list of all the table constraints in a database?

0 Answers  

---

What is a stored procedure?

3 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---