When do you create cluster and noncluster index?
Answer Posted / naren
If there is primary key in table clustered index created by
default ,other wise non cluster index created .
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the security principal at the server level that represents your session?
What is the xml datatype?
How to create a dml trigger using create trigger statements?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Why olap is used?
Can you force a query to use a specific index?
Explain system rowset functions?
How to transfer a table from one schema to another?
What is xdr?
What is implicit cursors?
How do I start sql server 2017?
Describe and explain about SQL native client?
Explain the different index configurations a table can have?
Explain features of analysis services?