What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

---

How to truncate a table first before running a package?

1 Answers  

---

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

---

How to use linked server?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

---

How to Execute an Operating System Command From Within SQL Server ?

3 Answers  

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

CLR Integration ? what is Notification services ?

1 Answers   HCL, Satyam,

---

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

---

Difference between Cluster and Non-cluster index?

32 Answers   Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

Please differentiate between a local and a global temporary table?

0 Answers  

---