What are the types of indexes available with SQL Server?
Answer Posted / guest
There are basically two types of indexes that we use with
the SQL Server. Clustered and the Non-Clustered.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Does server sql treat char as a variable-length or fixed-length column?
What does <> symbol mean?
Does order by actually change the order of the data in the tables or does it just change the output?
What is triggers and its types?
Relational calculus is what type of language?
What is #table in sql server?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is set nocount on?
What is the name of the Database which IBM mainframe uses?
How can you insert null values in a column while inserting the data?
List the different types of joins?
What kind of problems occurs if we do not implement proper locking strategy?
How to include date and time values in sql statements?
What are the two authentication modes in sql server?
What is change data capture (cdc) in sql server 2008?