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 list all objects in a given schema?
What do you mean by SQL injection attack?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is table join?
What is normalization process?
What is the current limitation of the size of SQL Azure DB?
What do you mean by an execution plan? Why is it used? How would you view it?
What are two difference between sql azure and azure tables?
What are the different types of backups avaialabe in sql server 2005?
What is an indexing strategy?
What is ms sql server triggers?
What is delete query?
Do you know what is a with(nolock)?