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

What is the bookmark lookup and rid lookup?

0 Answers  

Why use update_statistics command in sql server?

0 Answers  

how to get the automatic backup of the database in the sql server

4 Answers  

What are the main control-of-flow T-SQL constructs?

1 Answers  

which backup strategy you are following at ur company

0 Answers  

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

What is difference statement and preparedstatement?

0 Answers  

Explain “not null constraint” in sql server?

0 Answers  

What is history table in sql server?

0 Answers  

What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers