SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Tell us how can you control the amount of free space in your index pages?
Answer:
You can set the fill factor on your indexes. This tells SQL Server how much free space to leave in the index pages when re-indexing. The performance benefit here is fewer page splits (where SQL Server has to copy rows from one index page to another to make room for an inserted row) because there is room for growth built into the index.
Download SQL Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what different steps will a SQL Server Developer takes to secure SQL Server? | Do you know what is DCL? |