what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What is a trace frag? Where do we use it?

0 Answers  

---

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

---

What factors you will consider calculating the storage requirement for that view?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Explain error handling in ssis?

0 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

How do you measure the performance of a stored procedure?

3 Answers   Infosys,

---

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  

---

Can primary key be null?

0 Answers  

---

Define indexes?

0 Answers  

---