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 data tier application?

145

---

what is nonclustered index

547

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

499

---

Do you know what is blocking?

543

---

What are the default system databases in sql server 2000?

541

---

---

How you provide security to cube? : sql server analysis services, ssas

539

---

Explain acid?

613

---

Explain what is use of dbcc commands?

515

---

What is indexed view? How to create it?

597

---

what are database files and filegroups? : Sql server database administration

505

---

How sql server executes a statement with nested subqueries?

511

---

What does this statement do @@rowcount?

554

---

Does partitioning help performance?

531

---

What is the process of indexing?

520

---

how can you check the level of fragmentation on a table? : Sql server administration

542

---