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 how dts is used to extract, transform and consolidate data?

0 Answers  

What is the most common type of join?

0 Answers  

Can you explain the types of Joins that we can have with Sql Server?

2 Answers  

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

0 Answers  

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

What are pages and extents? : SQL Server Architecture

0 Answers  

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

How to declare a cursor with "declare ... Cursor" in ms sql server?

0 Answers  

How to resolve the orphan use problem? : sql server security

0 Answers  

How to list all columns in a table using odbc_columns()?

0 Answers  

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

What are the restrictions while creating batches in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories