What is the basic difference between clustered and a
non-clustered index?
Answer Posted / meera
Clustered index is unique for a table and 249 non-clustered
can be created.The leaf contains data and in non-clustered
the keaf node contains reference to the data.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
where can you add custom error messages to sql server? : Sql server administration
What is cube dimension? : sql server analysis services, ssas
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
What is SQL Azure Federations?
what is the system function to get current user's user id? : Sql server database administration
How global temporary tables are represented and its scope?
What is acid db?
What are the components of dbms?
What is dynamic cursor in SQL SERVER?
Explain an incremental backup?
What does REVERT do in SQL Server 2005?
What is forward - only cursors / read only cursor?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
When I run the sql server 2000 setup, it just hangs. What do I do?
Define outer join?