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
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is lookup override?
What is the difference between a check constraint and a rule?
What is a derived table?
Explain what is scheduled job and how to create it?
Explain view in sql server?
What is compound operators?
How to start and end transact-sql statements?
What is sql server 2000 work load governor?
What are data files?
What are the different normalization forms?
What is the difference between a primary key and a unique key? Are they the same?
What are the built in functions in sql server?
What is the process of normalising?
What is constraints and its types?