Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54219 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / grish varshney
yes, we can create the cluster index on non prime attribute
if it is unique & there is no prime attribute bcoz the
cluster index should be once..
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How you can add messages to the nt event log from within a stored procedure?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What are distributed partitioned views?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What are various aggregate functions that are available?
Explain what is lock escalation and what is its purpose?
What is the difference between SQL notification and SQL invalidation?
What is a with(nolock)?
Write an sql query to find first weekday of the month?
Find columns used in stored procedure?
What is the most common type of join?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
How to create a dynamic cursor with the dynamic option?
What is apply operator in sql?
What are the properties of the relational tables?
