Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

Using the customer, and order table in northwind database, please write a query to produce xml?

0 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What is the difference between implicit and explicit transaction?

0 Answers  

---

Explain how many normalization forms?

0 Answers  

---

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  

---

Do you know what is xpath?

0 Answers  

---

What is meant by datasource?

0 Answers  

---

what is a transaction? : Sql server database administration

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---