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
- 9375 Views
- iGate, Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Do you know what are acid properties of transaction?
What are the underflow and overflow behaviors on float literals?
Explain the advantages of merge replication?
How many types of triggers in sql server?
What stored by the msdb? : sql server database administration
How to transfer data from a cursor to variables with a "fetch" statement?
How can I tell if sql server is 32 or 64 bit?
What is left outer join in sql server joins?
How to use copy and concatenate commands in SQL?
What are the dmvs?
What is extended stored procedures?
How to backup encryption key ?
what are database files and filegroups? : Sql server database administration
Explain ms sql server reporting services vs crystal reports?
How can I create a report based on a query? : sql server management studio
