What is mean by "fill factor" ? and what is mean
by "Index "in sql?
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
How to query multiple tables jointly?
Explain how you can deploy an SSRS report?
Can you explain different types of joins?
What is sql profiler. What are the default templates with it? : sql server database administration
Can you tell me some of the common replication dmv's and their use? : sql server replication
What is xml datatype?
How to send email from database?
What are the reporting services components?
Explain the Ways to improve the performance of a sql azure database?
How can you append an identity column to a temporary table?
How to replace the Query Result 'Null Value' with a text ?
Comment,Datatypes are unlimited
How to test odbc dsn connection settings?
how many no of arguments can be passed in procedures and functions
Difference between 2NF &3NF ?