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
- 21763 Views
- I also Faced
- E-Mail Answers
Answer Posted / honnur swamy
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 ? | 33 Yes | 3 No |
Post New Answer View All Answers
Explain comment on transactions?
Difference between LEN() and DATALENGTH() in sql server ?
Explain about SQL server 2005?
Can you explain what is sql server english query?
What do you mean by cardinality?
Explain different types of collation sensitivity?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is the significance of master, tempdb and model databases?
What is inner join? Explain with an example?
How is sql server used?
What are the encryption mechanisms in sql server?
What is normalization? Explain its different types?
How can delete duplicate records in cte in sql server?
What are the types of normalization?
How would you add a section to a table?
