Interested to Buy Any Domain ? << Click Here >> for more details...
What is mean by "fill factor" ? and what is mean
by "Index "in sql?
- 1 Answers
- 9283 Views
- iGate, Logica CMG, I also Faced
- E-Mail Answers
Answer / gunjan sapra
fill factor is a defiened percentage between 0 to 100 in
which we leave exra gaps to accomodate future expansions in
the storage of the futures data.
indexing in sql is same as the index in our books. it helps
us to manage our data more appropriately.it can be done in
two ways namely clustered index and non-clusterd index.
we can create only one clustered index per table and
maximum of 249 non-clustered indexes per table.
| Is This Answer Correct ? | 15 Yes | 6 No |
List out the difference between union and union all in sql server?
How to enforce security in sql server? : sql server security
Does partitioning improve performance sql server?
Mention the command used to rename the database.
Can you explain what are commit and rollback in sql?
What are examples of triggers?
what is difference between having and where clause ?
What are commonly used odbc functions in php?
What is surrogate key? : sql server analysis services, ssas
Equi join and non equi join is possible with sql server?
what exactly sql injuction.how to overcome.....
What is a covered index?
-
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)
