What are the new features in SQL Server 2005 when compared to SQL Server 2000?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

0 Answers   Crown Solutions,

---

What does <> symbol mean?

0 Answers  

---

What are scheduled tasks in sql server?

0 Answers  

---

What are the different types of cursor?

0 Answers   HCL,

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

What do you mean by stored techniques? How would we use it?

0 Answers  

---

What happens if null values are involved in arithmetic operations?

0 Answers  

---

Why can there be only one clustered index and not more than one?

0 Answers  

---

What are the Pre Requisites when you apply Srvice Packs?

1 Answers   IBM,

---

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

8 Answers  

---