WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / muthu
Clustered index based on Primary Key. So if we create a PK,
automatically Clustered Index will be created. So only one
CI available for a table.
Is This Answer Correct ? | 10 Yes | 14 No |
Post New Answer View All Answers
Is BCNF better than 2NF & 3NF? Why?
What do you understand by intent locks?
What are different types of collation sensitivity?
How to rebuild indexes with alter index ... Rebuild?
What are the properties of the relational tables?
What are different replication agents and what's their purpose? : sql server replication
What is side by side migration in sql server?
What are trace flags and mention a few common trace flags used with sql server?
Tell me what is de-normalization and what are some of the examples of it?
What are the different types of sql server replication? : sql server replication
What is subquery? Explain the properties of a subquery?
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 index in an assignment?
What is an identity?
When to use Inner join & when to use subquery?