The index one sees in the beginning of a book is a clustered index and th

Difference between Cluster and Non-cluster index?

Question Posted / helps

Answer Posted / helps

The index one sees in the beginning of a book is a
clustered index and the index one sees at the end of the
book is a non clustered index.

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is row-level compre?

941

Explain time data type in sal server 2008?

870

How will you add a dimension to cube? : sql server analysis services, ssas

1012

Benefits of Stored Procedures?

918

What are logical database components? : SQL Server Architecture

959

What are different types of database indexes?

1011

How can sql server instances be hidden?

894

What are the basic functions for master, msdb, model, tempdb and resource databases?

938

Explain full-text query in sql server?

951

What is filter index?

908

Explain the concept of recursive stored procedure.

879

Explain what are the restrictions that views have to follow? : SQL Server Architecture

991

What are security principals used in sql server 2005?

905

Explain mixed authentication mode of sql server?

989

Explain isolation levels that sql server supports?

986