Interested to Buy Any Domain ? << Click Here >> for more details...
how many non clustered index in sql server 2008,2010,2012
- 2 Answers
- 7258 Views
- Accenture, I also Faced
- E-Mail Answers
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 |
Explain important index characteristics?
Can two tables share a primary key?
Explain active/passive and active/active cluster configurations?
Can we use trigger new in before insert?
Explain alternate key, candidate key and composite key in sql server?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Can you tell me about the concept of ER diagrams?
What is the significance of null value and why should we avoid permitting null values?
what is a schema in sql server 2005? : Sql server database administration
What is dbcc?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Define msdb database?
-
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)
