Select from following answers:- True (for SQL Server 2005 and later)
- True (for SQL Server 2000 and later)
- False
- True (for all SQL Server versions)
- All Above
Whenever an index is created or rebuilt, the fill factor option can be used to determine the percentage of free space (if any) on each leaf level page of the index. A fill factor of 0 or 100, both tell SQL Server that the fill factor should be 100, and leaf level pages are to be filled to full capacity.
Show Correct Answer
Asked In: In General |
Alert Moderator