What are the type of Indexes? which one is best, why?
- 6 Answers
- 8548 Views
- I also Faced
- E-Mail Answers
Answer Posted / amit choubey
clusterd and non clusterd
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a db view?
How can you know if the row fetched from cursor is still valid in underlying table?
What is the difference between a stored procedure and a user defined function?
How does recursive cte works in sql server?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is the difference between grant and with grant while giving permissions to the user?
Explain various On-Delete options in a DB table. Which is the default option?
Are resultset updatable?
Define outer join?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Explain the working of sql privileges?
Explain what is row_number function?
What encryption security is available in sql azure?
Explain what is use of dbcc commands?
Explain what is log shipping?
