Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54111 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / surya prakash
Finally, i want to conclude by saying.
1. We can create Clustered Index on Non-Primary Key Columns
and this table should not contain any other column with
Primary Key.
2. It is recommended that we create Clustered Indexing on
Primary Key Columns
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What is the difference between seek predicate and predicate?
Why people hate cursor?
How to enforce security in sql server? : sql server security
why would you call update statistics? : Sql server database administration
What is the correct order of the logical query processing phases?
what do you understand by change data capture?
What is explicit mode in sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
Explain the difference between delete,drop and truncate in SQL Server?
Where in ms sql server is ’100’ equal to ‘0’?
What does the on delete cascade option do?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
