Can we create clustered index on non primary key column
- 20 Answers
- 51672 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
Explain external key management in sql server 2008
Explain transaction server auto commit?
How efficient you are in oracle and SQL server?
What is explicit cursors?
What are the advantages of stored procedure in sql server?
Does union all remove duplicates?
Mention the differences between substr and charindex in sql server.
What are the steps to insert a table?
Write a query to find 5th highest amount paid from the customer table.
What are the disadvantages of using querystrings to send data from one page to another?
Why people hate cursor?
What is @@error in sql?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Tell me what is log shipping?
Do you know the different ddl commands in sql?
