Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / manisha
cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.
a table can have max of 1 clustered index but can have upto
249 non clustered index.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the synonym of join?
What is transaction server implicit?
How to sort the query output with order by clauses in ms sql server?
What are tables in sql server?
What is RMS migrations?
Explain system functions or built-in functions? What are different types of system functions?
How to set database to be read_only in ms sql server?
Is mysql better than sql server?
What is difference between materialized view and view?
How to create new tables with "select ... Into" statements in ms sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the different types of backups avaialabe in sql server 2005?
Explain the properties of subqueries in sql server?
How to read data in a table with "select" statements?
