Explain log shipping and mention its advantages.

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

What is an identity?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

How to count the number of duplicate items in a table?

3 Answers  

---