how many non clustered index in sql server 2008,2010,2012

Question Posted / dilipkumar

2 Answers
6510 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how many non clustered index in sql server 2008,2010,2012..

Answer / dilipkumar

there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Is This Answer Correct ?

15 Yes

1 No

how many non clustered index in sql server 2008,2010,2012..

Answer / vikram

there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is difference between stored procedure & function?

3 Answers CarrizalSoft Technologies, Concept Infoway, TATA,

Do you know what are acid properties of transaction?

0 Answers

How to use transact-sql statements to access the database engine?

0 Answers

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers

Explain what are various ways to enhance the ssrs report?

0 Answers

How to check if a table is being used in sql server?

0 Answers

How do I create a stored procedure in sql server?

0 Answers

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers C3I, eSoft, iPRO Solutions, Wipro,

Do you know what are the steps to process a single select statement?

0 Answers

What do you understand by intent locks?