Can we create a clustered index on composite primary key.

3 Answers   IGT,

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

Explain what are partitioned views and distributed partitioned views?

0 Answers  

---

What happens to a statement batch if there is a compilation error?

0 Answers  

---

What is a join in sql?

0 Answers  

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

How do I view a script in sql server?

0 Answers  

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What is the diff between Static Queries and Dynamic queries give me some examples

2 Answers   CSC,

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

---

Tell me what is difference between view and materialized view?

0 Answers  

---

What is reference section?

0 Answers  

---