Answer Posted / praveen
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 ? | 4 Yes | 6 No |
Post New Answer View All Answers
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is a trace frag? Where do we use it?
What is replace and stuff function in sql server?
What is difference between index seek vs. Index scan?
Why do we use stored procedures in sql server?
What is a subquery in a select query statement in ms sql server?
What is your recommendation for a query running very slow? : sql server database administration
What is the difference between a unique key and primary key?
Define Joins?
How do you use a subquery to find records that exist in one table and do not exist in another?
Can coalesce return null?
How can we improve performance by using SQL Server profiler?
What is the log shipping?
What are the ways available in sql server to execute sql statements?
What is lookup override?