Answer / manoj

As per MSDN there are 9 types:
http://msdn.microsoft.com/en-us/library/ms175049.aspx

Answer / abcd

9 indexes:

1. Clustered,
2. Non-clustered,
3. Unique,
4. Index with included columns,
5. Indexed views,
6. Full text,
7. Spatial,
8. Filtered &
9. XML

Answer / chandra bhan singh

Three Type of indexes in sql

1.Clustered
2.Non-clustered
2.Primary XML

Answer / b.hari kumar reddy

mainly five type of indexes in sql

1.simple index
2.composite index
3.unique index
4.Clustered index
5.Non-clustered index

Answer / mohd zubair khan

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

Answer / rohti nanda

Three type of indexes in sql

1.Clustered
2.Non-clustered
3.Unique

List out the differences between global and local temp tables in sql server?

0 Answers  

What is Schema? and why we use schemas?

4 Answers  

How to receive output values from stored procedures?

0 Answers  

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

What is service broker?

0 Answers  

What is blocking and how would you troubleshoot it?

2 Answers  

What is the default schema of your login session in ms sql server?

0 Answers  

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

0 Answers  

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

0 Answers  

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

How to get nth highest salary from employee table.

0 Answers