Answer Posted / hiral bhatt
No, its not possible to hving Primary key with Non Clusterd
Index, because whenever we have to make a column as Primary
Key, it will create a Clusterd Index on that Column
automatically, it is due to the concept of paging, thats
why we can have only 1 primay key and 1 clusterd index per
Table...Enjoy :-)
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
how you can deploy an ssrs report?
Can we shrink data file in sql server?
Can you type more than one query in the query editor screen at the same time?
How do you create an execution plan?
Tell me about normalization in DBMS.
What is the contrast between sql and mysql?
What are the reporting services components?
What is a field in a table?
What is merge join?
Explain different types of Normalization.
How do I find the port number for sql server?
Define union, union all, minus, intersect?
Is sql server implemented as a service or an application? : Sql server database administration
How to convert numeric expression data types by assignment operations?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
