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
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
what is normalization? Explain different levels of normalization? : Sql server database administration
How to transfer data from a cursor to variables with a "fetch" statement?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What do you know about normalization and de- normalization?
What is the native system stored procedure to execute a command against all databases?
How can you know if the row fetched from cursor is still valid in underlying table?
How to encrypt Strored Procedure in SQL SERVER?
Explain view in sql server?
How to use subqueries in the from clause in ms sql server?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What is a collation in ms sql server?
What is a transactions?
what is nonclustered index
List the ways in which dynamic sql can be executed?