What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

Describe how to use linked server?

0 Answers  

---

What are different types of join?

0 Answers  

---

What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?

8 Answers   Microsoft,

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

---

Can you explain the role of each service?

1 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

what type of indexes physically sort data?

3 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

What is the difference between drop table and truncate table?

0 Answers  

---

What is explicit mode in sql server?

0 Answers  

---