WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / samrat sen
Clustered Index creation does not depend upon primary key ,
it can be created on any column, but the write answer is
whenever we create clustered index on a table it physically
sorts the column values, so another clustered index is not
possible.
Is This Answer Correct ? | 14 Yes | 10 No |
Post New Answer View All Answers
What stored procedure can you use to display the current processes?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
How to skip remaining statements in a loop block using continue statements?
How do I port a number to sql server?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
optimization techinques
What are pessimistic lock and optimistic lock?
How many non clustered indexes there can be on table ?
Does sql server 2000 clustering support load balancing?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Can we shrink data file in sql server?
How many types of functions are there in sql server?
How to configure odbc dsn with different port numbers?