Answer Posted / mandar kavishwar

Indexes in databases are similar to indexes in books. In a
database,an index allows the database program to find data
in a table without
scanning the entire table.
There are two types of Index in MS-SQL.
1.Clustered
2.Non-Clustered
In MS-SQL Server 2005,
Only 1 Clustered & 249 Non-Clustered Possible.So (Total 250)
But in MS-SQL Server 2008,
Only 1 Clustered & 999 Non-Clustered Possible.(Total 1000)

What is reference section?

505

---

Is foreign key unique?

581

---

What is trigger explain with program?

540

---

What is the purpose of the model database?

604

---

How to receive output values from stored procedures?

487

---

---

How to restore performance issues and how to check?

1529

---

What is the datatype of rowid?

512

---

What is a mixed extent?

597

---

What are the types of lock supported by ?

616

---

What is a dataset and what are the different types of datasets?

93

---

How to verify the port number of the sql server?

563

---

What is the purpose of the tempdb database?

577

---

What is sql server replication? : sql server replication

541

---

How to insert a new row into a table with "insert into" statements in ms sql server?

541

---

What are the benefits of filtered indexes?

518

---