Which index created when Create Index on table(col), Why

Answer Posted / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Should you normalize audio?

525


Write a program to fetch first 10 records from a file?

600


What is instead of trigger sql server?

495


How to add the custom code in Report?

99


What are the new security features added in sql server 2012? : sql server security

532






What is shared lock?

487


New concepts of sql server 2005 use in your project.

1910


explain different levels of normalization? : Sql server database administration

522


How to round a numeric value to a specific precision?

569


How do I find the size of a sql server database?

489


How to create user messages with print statements in ms sql server?

588


What is difference between getdate and sysdatetime in sql server 2008?

600


What is sql server 2000 work load governor?

554


What is the difference between left and right outer join?

541


Explain collation?

618