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
- 21753 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhijit
A clustered index sorts and stores the data rows in the
table based on the index key values. Therefore only one
clustered index can be created on each table because the
data rows themselves can only be sorted in one order.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What do you understand by triggers?
What is the difference between Stored Procedures and triggers?
Where the sql logs gets stored? : sql server database administration
what is checksum in sql server.........???
What is a db view?
Explain filestream storage of sql server 2008?
Write a SQL query to delete a table?
Can we install sql server 2016 on windows 7?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Tell about MOM Tool(Microsoft Operator Manager)?
Explain the dbcc pintable command when would you use it?
What are the 7 disadvantages to a manual system?
What do you understand by integration services in sql server?
Can multiple columns be used in sql group by clause in ms sql server?
What are different types of statements that are supported by sql?
