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  

---

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What is log cache in sql server?

0 Answers  

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

Explain the purpose of indexes?

0 Answers  

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

0 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---