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

Who is the owner of a schema in ms sql server?

0 Answers  


How do you delete a trigger?

0 Answers  


What is 1nf 2nf and 3nf?

0 Answers  


How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  


How to retrieve error messages using odbc_errormsg()?

0 Answers  


Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  


Can we call stored procedure in view in sql server?

0 Answers  


How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  


Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  


Explain identity in sql server?

0 Answers  


What is a not null constraint?

0 Answers  


Categories