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
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
How to delete existing triggers using "drop trigger"?
Give me any three differences between Truncate and Delete.
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How do database indexes work?
What is the use of set nocount on/off statement?
List types of tables in SQL Azure?
How are the unique and primary key constraints different?
What is a periodical index?
Does an index slow down updates on indexed columns?
What is efficiency data?
What is used to replicate sessions between instances in coldfusion clusters?
What are the advantages of using cte?
Is INSTEAD OF trigger directly applicable to Table ?
What are the advantages of user-defined functions over stored procedures in sql server?