SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
How to 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 in to the index.
Download SQL Server DB Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is database isolation in SQL Server? | How to create a Scrollable Cursor with the SCROLL Option? |