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
Define left outer join?
What is normalization process?
How can I track the changes or identify the latest insert-update-delete from a table?
What is optimistic concurrency?
When would you use it?
What are the types of user defined functions in sql server?
Define full outer join?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is in place upgrade in sql server?
Explain important index characteristics?
How to provide values to stored procedure parameters in ms sql server?
Explain filtered indexes benefits?
How to call a function from a stored procedure in SQL Server ?
How to create view in stored procedure sql server?
What are sp_configure commands and set commands?