Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajkumar
There can be only 1 Clustered index in a table
where as nonclustered index can be upto 249
Clustered is physical sorted index..
non clustered is logical stored index is faster than
clustered index
thats all i know
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to see the event list of an existing trigger using sys.trigger_events?
Which are ddl commands?
Explain transaction isolation levels in sql server?
What are the difference between primary key and unique key? : sql server database administration
What are the different authentication modes in sql server? How can it be changed?
can you instantiate a com object by using t-sql? : Sql server database administration
What are the different types of backups avaialabe in sql server 2005?
What is a covered index?
What is the difference between Clustered and Non-Clustered Index?
Can I delete event logs?
What are different types of collation sensitivity?
Difference between Inner vs outer joins?
How can you set the threshold at which sql server will generate keysets asynchronously?
your distribution database is full what will u do
What is a subquery in a select query statement in ms sql server?
