Answer Posted / vikram

there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

What are the characteristics of modern DBMS?

1137

---

can a database be shrunk with users active? : Sql server administration

1058

---

How is SQL Azure different than SQL server?

225

---

Explain different types of locks in sql server.

1124

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

989

---

Difference between report and query parameter.

1139

---

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

---

Can you pass expressions to stored procedure parameters?

1081

---

List the data types available in mssql?

1097

---

what is a mixed extent? : Sql server administration

1169

---

What is query cost in sql server?

1035

---

How to insert data with null values?

1076

---

What is a View ? Can we insert, Update and delete a view?

1056

---

List out the differences between the clustered index and non-clustered index in sql server?

1046

---

What are the filtered indexes?

1091

---