About types of indexes in SQL server ?

Question Posted / shaheen

Answers were Sorted based on User's Feedback

About types of indexes in SQL server ?..

Answer / pandian

There are two types of indexs.
1. Cluster Index (Ex. Primary Key)
2. Non Cluster Index(Ex.Unique Key)

Is This Answer Correct ?

9 Yes

3 No

About types of indexes in SQL server ?..

Answer / bala

Filtered Index in case of SQL Server 2008

Is This Answer Correct ?

0 Yes

3 No

More SQL Server Interview Questions

How to stop a loop early with break statements in ms sql server?

Disadvantages of the indexes?

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

What is the maximum size of sql server database?

what command is used to create a table by copying the structure of another table?

1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........

hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

Explain system scalar functions?

How do I view a trc file?

What area unit the various kinds of info compression introduced in sql server 2008?

For more SQL Server Interview Questions Click Here