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
What is the recursive stored procedure in sql server?
Explain what is scheduled job and how to create it?
How to enter binary string literals in ms sql server?
Difference between LEN() and DATALENGTH() in sql server ?
Explain the stored procedure?
Explain how to integrate the ssrs reports in application?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How to perform key word search in tables?
what is denormalization and when would you go for it? : Sql server database administration
What is best institute to Learn DotNET And SQL in chennai?
What are the types of ssrs?
Explain filestream storage of sql server 2008?
Show Practically Sql Server Views are updatable?
Define master database?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
