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 |
Describe about first three Normal forms.
What is difference beteen Migration and Upgrdation?
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
How can we use ConnectorJ JDBC Driver with MS SQL?
Why transaction is important?
i want table name basis on column name.
What is the difference between having clause and where clause in sql server?
What are the built in functions in sql server?
What do you understand by coalesce in sql server?
List some of the rules that apply to creating and using a ‘view’
please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on
What is the difference between SSAS 2000 and SSAS 2005?
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)