What is an Covering Index ?

An index that is constructed such that SQL Server can completely satisfy queries by reading only the index is called a covering index.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maximum no of NonClustered indexes for a table?

1000

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is a Forwarding Pointer ?

If SQL Server must move the row by subsequent modifi cations, such as a page split or the row no longer fi ts on the data page, SQL Server does not update the nonclustered index with the new location of the row. Instead, SQL Server creates a forwarding pointer on the data page pointing to the new location of the row.

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maxium size of the Index Key?

900 bytes

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning

What is the maximum columns you can create an Index with ?

16

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning