diffrence between Cluster Index and non Cluster Index
Answer Posted / naren
Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is check constraint in sql server?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is the purpose of the model database?
How can we migrate from SQL server to SQL Azure?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is dknf in normalization form?
What is the purpose of the tempdb database?
What is the synonym of join?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Explain what is the main purpose of having conversation group?
What is implicit cursors?
What are the different types of collation sensitivity?
Can you explain various data region available in ssrs with their use?
Can you name a few encryption mechanisms in sql server?
What is the maximum size of a row in sql server?