What is the difference between referencing and joining?

1 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

What is logshipping and its purpose?

0 Answers  

---

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  

---

---

Is there any difference between the primary key and unique key?

0 Answers  

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

0 Answers  

---

Why do we backup Active Directory ?

0 Answers  

---

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

---

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

---