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 views used for?

613

---

How do you troubleshoot errors in a SQL Server Agent Job?

554

---

What is transact-sql language?

574

---

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

600

---

What do you mean by data integrity?

589

---

---

How to count duplicated values in a column in ms sql server?

508

---

what are the Prerequisites for Replication?

10557

---

Which table keeps information about stored procedures?

529

---

Show Practically Sql Server Views are updatable?

586

---

Explain filtered indexes benefits?

593

---

What are the three different part of rdl file explain them?

168

---

What are the types of processing and explain each? : sql server analysis services, ssas

736

---

What are logical/boolean operations in ms sql server?

535

---

What protocol does sql server use?

511

---

What are the new data types are introduced in sql 2000?

495

---