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 |
How to download and install the scaled-down database adventureworkslt?
How to declare and use cursor variables?
what is the system function to get the current user's user id? : Sql server database administration
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is a performance monitor?
What is plan freezing?
What is raid and what are different types of raid levels?
How do you implement session management in SQL Server mode?
Is it possible in sql table to have more than one foreign key?
Tell about MOM Tool(Microsoft Operator Manager)?
How will you optimize a stored procedure optimization?
What is the dbcc command and why is it used?
Oracle (3259)
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)