WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?
- 8 Answers
- 19737 Views
- I also Faced
- E-Mail Answers
Answer Posted / raju.r
we can create ony ONE clustered index per table .. for Non-
clusrtered index we can create 249 ...
| Is This Answer Correct ? | 4 Yes | 11 No |
Post New Answer View All Answers
How to make remote connection in database?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
what are the important architecture components of SSRS?
Write query to return all rows sql?
Explain error and transaction handling in sql server?
What triggers long term care?
Why I have to use stored procedures?
Explain Capacity planning to create a database? and how to monitor it?
What is the purpose of forms?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are the five characteristics of good data?
1 01 101 01010
What is sql server transaction log file?
Which joins are sql server default?
Tell me when is the update_statistics command used?
