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
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 drillthrough reports?
What is function of master database?
What are the fixed server level roles? : sql server security
Is the primary key column of a table an index in ms sql server?
What are the different type of replication in sql server?
What programming language would you use to create embedded functions in ssrs?
Write a sql query to delete duplicate records from a table called table1
Can binary strings be converted into numeric or float data types?
How many types of keys are there?
Does index slows down insert statements?
How to make remote connection in database?
What are the types of subquery?
Write a SQL queries on Self Join and Inner Join.
What is RMS migrations?
