we can create ony ONE clustered index per table .. for Non- clusrtered ind

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / raju.r

Answer Posted / raju.r

we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...

Is This Answer Correct ?

4 Yes

11 No

Please Help Members By Posting Answers For Below Questions

What is the most common type of join?

984

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1125

How to copy data from one table to another table?

990

What is the difference between for auto and for nested?

997

How to generate create procedure script on an existing stored procedure?

1002

What are the three different part of rdl file explain them?

265

Where is trigger in sql server?

1035

Explain few of the new features of sql server 2008 management studio

906

Define left outer join?

957

Can group functions be used in the order by clause in ms sql server?

1007

What are different types of statement?

1004

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

970

Explain transaction server isolation?

1016

what's the difference between a primary key and a unique key? : Sql server database administration

936

Why is the need for data conversion transformations?

1047