Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create clustered index on non primary key column
- 20 Answers
- 54805 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / madhav
yes we can create clusterd index on non primary key. but
the primary key must should be a non clusteresd index
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
Do you know the isolation level that sql server support?
What are the key configuration files for sql server reporting services ?
Can coalesce return null?
Give me a SQL Query to find out the second largest company?
How to loop through result set objects using mssql_fetch_array()?
What is sqlcmd?
What is the difference between a stored procedure and a user defined function?
Explain stored procedure?
How to provide column names in insert statements in ms sql server?
According to you what goes into making the best database administrator? : sql server database administration
How many categories of data types used by sql server?
What are ddl triggers and types of ddl trigger?
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
What is a cursor, index in sql?
