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
How much space does sql server 2016 take?
List out some of the requirements to set up a sql server failover cluster?
Why do we backup Active Directory ?
What is SQL Azure Fabric?
How we can refresh the view?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
Can you type more than one query in the query editor screen at the same time?
what is difference between view and Dip.
What area unit the various kinds of info compression introduced in sql server 2008?
Do you know concepts and capabilities of sql server?
What is correlated subquery in sql server?
How to set database to be single_user in ms sql server?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is clustered vs nonclustered index?