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 is the primary use of the model database? : Sql server administration

1061

---

How to update a field in SQL after ALTERING a row?

1243

---

What are approximate numeric data types in ms sql server?

1070

---

How to generate create table script on an existing table in ms sql server?

1157

---

What is difference between view and materialized view?

943

---

What is the difference between delete and truncate statements?

1091

---

Difference between Sql server reporting services and Crystal reports?

172

---

What different steps will a sql server developer take to secure sql server?

1001

---

What is save transaction and save point?

1215

---

What is the need for group functions in sql?

1097

---

What is the default schema of your login session in ms sql server?

1058

---

What is public role in sql server?

1161

---

How do I know if localdb is running?

963

---

Which are the olap features?

968

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1973

---