Interested to Buy Any Domain ? << Click Here >> for more details...
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 21540 Views
- I also Faced
- E-Mail Answers
Answer Posted / samrat sen
Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.
| Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
What are different types of roles provided by ssrs?
What is the difference between local and global temporary tables?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is merge replication?
How to delete an existing database user?
Can we add an identity column to decimal datatype?
How to update values in a table with update statements in ms sql server?
explain different types of joins? : Sql server database administration
Tell me what is fill factor?
Explain in brief how sql server enhances scalability of the database system?
How to write a query with a left outer join in ms sql server?
What is openxml in sql server?
What are the restrictions applicable while creating views? : SQL Server Architecture
optimization techinques
What is side by side migration in sql server?
