Explain the difference between clustered and non-clustered index?

0 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

How column data types are determined in a view?

0 Answers  

---

What is the function of inner join?

0 Answers  

---

Does transparent data encryption provide encryption when transmitting data across the network?

0 Answers  

---

---

What is primary key, unique key, and foreign key?

0 Answers  

---

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

0 Answers  

---

How to test a dml trigger in ms sql server?

0 Answers  

---

How to list all user defined functions in the current database?

0 Answers  

---

What is a function? Give some example?

3 Answers  

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---