Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / dilipkumar

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

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

How to get the definition of a trigger back?

0 Answers  

What do you mean by data manipulation language?

0 Answers  

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

What are “phantom rows”?

0 Answers  

How to write a query with an inner join in ms sql server?

0 Answers  

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

How extra digits are handled with numeric data type literals?

0 Answers  

Explain the functionalities that views support?

0 Answers  

How to enable/disable indexes?

0 Answers  

What is the maximun sixes of .mdf in sql server 2005

1 Answers  

For more SQL Server Interview Questions Click Here
Categories