Question 22

Answer D is correct. You know that 25,000 is 50% of 50,000, so filling the page by 50% and leaving 50% free space for the remaining 50,000 records seems logical. The default FILLFACTOR setting of 0 doesn't leave any room for additions, which would slow inserts. If you set the FILLFACTOR value too big, searches slow down because any query processed has to cycle through a lot of empty space.

For more information, see the following sources:

  • Chapter 2, "Creating Database Objects"

  • SQL Server 2005 Books Online: "Building SQL Server Applications, SQL-DMO, SQL-DMO Reference, Properties, F, FILLFACTOR"

  • "Fill Factor,"

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: