Can we create nonclustered index in a table without
creating a clustered index
Answer / neelesh kumar
Yes, we can. for example we can use unique constraint
without any clustered index.
Is This Answer Correct ? | 16 Yes | 1 No |
How do you fine the performance tunning?
Explain the difference between delete,drop and truncate in SQL Server?
What is cursor in ms sql server?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How can you check the level of fragmentation on a table?
what is diffence between replicaion and logshipping?
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer.
Differentiate between delete and truncate.
How would you choose between a clustered and a non-clustered index?
How to get the definition of a trigger back?
Can you explain different types of locks in sql server?
What is DCL?