DBA > Job Interview Questions > Microsoft SQL Server Database Administrator Exam

By default, MS SQL Server sets the index fill fa

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

By default, MS SQL Server sets the index fill factor to 100%. What does this mean?

With the default setting for fill factor to 100%, MS SQL Server will fill pages used by indexes as much as possible and leave no free space on them. It is very efficient in terms of memory usage.
But it will impact the performance with inserting new records, because new pages need to be added immediately.

(Continued on next question...)

Other Job Interview Questions