What is an Covering Index ?
Thursday, June 7, 2012
Labels:
Interview Questions and Answers,
SQL DBA,
SQL Server
What is the maximum no of NonClustered indexes for a table?
Labels:
Interview Questions and Answers,
SQL DBA,
SQL Server
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
Labels:
Interview Questions and Answers,
SQL DBA,
SQL Server
Subscribe to:
Posts (Atom)