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

Answer Posted / samrat sen

yes,you can only create one clustered index on a table.

Is This Answer Correct ?    10 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different types of replication in sql server?

748


What do you do in data exploration

720


What is the boxing and unboxing concept in .net?

710


How to stop log file growing too big?

747


What is tablesample?

766






How to insert multiple rows with one insert statement in ms sql server?

791


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

706


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

737


What samples and sample databases are provided by microsoft?

760


Why use cursor in sql server?

733


Explain error handling in ssis?

754


How to get a list of all tables with "sys.tables" view in ms sql server?

765


Explain the properties of the relational tables?

720


Can sql server be linked with other servers like oracle?

700


What is amo? : sql server analysis services, ssas

836