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

Can we store videos inside the sql server table?

1020

What is ms sql server service broker?

1035

What is read committed?

1166

How can you check the level of fragmentation on a table?

1086

What does the not null constraint do?

1176

What is raid? : SQL Server Architecture

1223

What is 1nf normalization form?

1078

What is scan table/view and seek table/view when its occurs? : sql server database administration

1087

What is data source view or dsv? : sql server analysis services, ssas

1053

Can we insert data if clustered index is disabled?

981

Explain stored procedure?

1107

How to make a column nullable?

1171

How many database files are there in sql server 2000?what are they?

1100

do views contain data ?

1017

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1112