WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
Answer Posted / samrat sen
yes,you can only create one clustered index on a table.
| Is This Answer Correct ? | 10 Yes | 12 No |
Post New Answer View All Answers
Do you know spatial data types - geometry and geography in sql server 2008?
What is 1nf normalization form?
What is inline table-value user-defined function?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
What is nolock hint in sql server 2008
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What are the different types of stored procedures?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Why do we need different type of parameter?
How to replace the Query Result 'Null Value' with a text ?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Can we store videos inside the sql server table?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How to perform key word search in tables?