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 do you mean by an execution plan?
What are the pre-defined functions in the sql server?
Explain the steps to use transact-sql cursor?
What is log shipping?
Why Master database is required?
Give an example of why you would want to denormalize a database
How do I find information about the install locations for the various instances running on a computer?
What is the default port for SQL Server over a firewall?
What is the chart in report?
What is report snapshot?
Explain transaction server explicit transaction?
What is the new security features added in sql server 2014? : sql server security
What is user-defined functions? What are the types of user-defined functions that can be created?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is cursors? And what are the different types of cursor?