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...


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

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

How to download and install the scaled-down database adventureworkslt?

0 Answers  


How to declare and use cursor variables?

0 Answers  


what is the system function to get the current user's user id? : Sql server database administration

0 Answers  


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

0 Answers  


What is a performance monitor?

0 Answers  


What is plan freezing?

0 Answers  


What is raid and what are different types of raid levels?

0 Answers  


How do you implement session management in SQL Server mode?

0 Answers   Cap Gemini,


Is it possible in sql table to have more than one foreign key?

0 Answers  


Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  


How will you optimize a stored procedure optimization?

0 Answers  


What is the dbcc command and why is it used?

0 Answers  


Categories