Can we create clustered index on non primary key column
Answer Posted / sandeep
Yes, We can, only thing is that, we can create clustered
index only on one key.If table contains any clustered index
on any key(even on primary or on unique key) just drop it
and create it on desired key. after it you can create a non
clustered index on primary or on unique key.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to delete existing triggers using "drop trigger"?
What is the default value of an integer data type in sql server 2005?
What is a raid and what are different types of raid configurations?
Explain the properties of the relational tables?
How will you add a dimension to cube? : sql server analysis services, ssas
Where to find ntwdblib.dll version 2000.80.194.0?
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
How to find the second highest salary of an employee?
What is normalization and what are the advantages of it?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the types of resultset?
What is the difference between seek predicate and predicate?
How to create a new schema in a database?
What is normalization? Explain its different types?