What is the basic difference between clustered and a
non-clustered index?
Answer Posted / bhai(prakash.g)
clustered index is only one clustered index per table.
non clustered index is more than one in table.
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How to get the definition of a trigger back?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is the difference between Triggers and Stored Procedure?
Define model database?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Do you think BCNF is better than 2NF & 3NF? Why?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How do you handle datasets larger than 50 gb?
How many triggers you can have on a table?
What is Sqlpaging in SqlServer 2005 ?
Explain what is cte (common table expression)?
what is a sub-report?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?