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

Explain timestamp datatype?

0 Answers  

What is tempdb in sql server?

0 Answers  

What are Magic Table?

34 Answers   3i Infotech, Digiweb, Evalueserve, NIIT, PL,

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers  

how to find the second salary?

10 Answers   HCL, Prithvi,

what is call by value & call by reference ?

2 Answers   Cap Gemini,

How to turn off warning messages during php execution?

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories