Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54778 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
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain transaction server explicit transaction?
What are acid properties of transaction?
Explain use of expression builder.
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
What is the order by used for?
Why functions are used in sql server?
what are the disadvantages of cursors? : Sql server database administration
What is store procedure?
What is onf in normalization form?
How to compare the top two records using sql?
What is index fragmentation in ms sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
Can you explain different types of joins?
How to insert stored procedure result into temporary table?
