Question of the Day Three

Today we continue our Question of the Day series with question number three.  In case you are just joining us, we are doing a question a day as an exercise in SQL Learning.

What is fill factor?

My first response to this question in normal day-to-day conversation is that fill factor is a great SQL guy that I follow on twitter.   All joking aside, fill factor is an option that will determine how full to create each index page.  In other words, when the index page is filling up and does not have enough room to insert a new row, then SQL Server will generate a new index page and move some of the rows from the last index page to this new page.  This is known as a page split.  If we use the fill factor option, then the server will reserve a set amount of space on each index page and thus will reduce the number of page splits.  The default value for fill factor is 0.

Enjoy!

Advertisements

About SQLGator

Florida Gator and Microsoft Data Platform MVP, Star Wars fanatic and is there anything else...oh yeah PS4! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on August 5, 2012, in SQL Schoolhouse and tagged . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: