how many non clustered index in sql server 2008,2010,2012
Answers were Sorted based on User's Feedback
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 |
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 |
Who is the owner of a schema in ms sql server?
How do you delete a trigger?
What is 1nf 2nf and 3nf?
How do we get current date in SQL Server 2000, Oracle, MS Access?
How to retrieve error messages using odbc_errormsg()?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
Can we call stored procedure in view in sql server?
How to see the event list of an existing trigger using sys.trigger_events?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Explain identity in sql server?
What is a not null constraint?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)