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

Answer Posted / indexes

Non Clustered Index by Default.

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the various types of concurrency problem?

705


What is an etl file?

531


Define tool Manage Statistics in SQL Server 2000 query ?

528


Explain cdc and sql injection?

552


What is the Control Flow in SSIS

580






You want to use a perspective in an mdx query. How do you select the perspective?

157


Does sql server 2000 full-text search support clustering?

510


How to sort query output in descending order in ms sql server?

551


What happens if strings are casted into wrong code pages in ms sql server?

569


What is the name of the system variable that returns the number of rows affected by a SQL statement?

571


Can we add an identity column to decimal datatype?

589


Tell me what do you understand by a view? What does the with check option clause for a view do?

647


Explain ms sql server reporting services vs crystal reports?

505


What is data block and how to define data block size?

607


Can you roll back the ddl statement in a trigger?

527