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 are the new features of sql server 2008 r2 reporting service?

206

How to find table changes in sql server?

1097

Is truncate a dml command?

919

Do you know exporting and importing utility?

1022

what is difference between view and Dip.

2397

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1019

How do I find the transaction log size in sql server?

947

What is stretch database in sql server?

1053

Define ACID properties in a Database?

1045

List all the types of user-defined functions?

1071

Detail about the hardware which is supported by SQL server?

1046

What is sharding?

116

What Is Rdbms?

1133

How does stuff differ from the replace function?

993

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

969