Can we create clustered index on non primary key column
Answer Posted / venkat
yes we can create clustured index on non primary key,
But that column has unique values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we migrate from SQL server to SQL Azure?
Can you leave a union at any time?
Explain about Views?
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
Explain sub-query?
What is nonclustered index on computed columns?
Write a sql query to delete duplicate records from a table called table1
How to see existing views in ms sql server?
Define full outer join?
What is the filtered index?
Why it is recommended to avoid referencing a floating point column in the where clause?
What is indexed view?
What is nolock hint in sql server 2008
How to verify a login name with sqlcmd tool?
What is self contained sub query?