Can we create clustered index on non primary key column
- 20 Answers
- 51664 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / madhav
yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
can a table be moved to different filegroup? : Sql server administration
Is it possible in sql table to have more than one foreign key?
What is the difference between seek predicate and predicate?
What are the different authentication modes in sql server?
What is a performance monitor?
Can you move the resources after pausing the node? : sql server database administration
What are the different SQL Server Versions you have worked on?
What is a group function explain with an example?
What are security principals used in sql server 2005?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Is the order of columns in the set clause important in ms sql server?
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.
Mention the differences between having and where clause.
What is a virtual table in sql?
What is the difference between functions and scalar functions?
