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
What are the three different part of rdl file explain them?
How to copy the tables, schema and views from one sql server to another?
List few advantages of stored procedure.
What is a non-clustered index?
Give main differences between "Truncate" and "Delete".
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
 Explain what is sql override for a source taLle in a mapping?
What is difference between delete & truncate commands?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How to delete a database in ms sql server?
What are the character string functions supported by sql server 2005?
What do you mean by subquery?
What is stretch database in sql server?
Explain differences between web edition and business edition?
Why do we use stored procedures in sql server?