Configure instance properties continued

- [Narrator] In our previous video…for the instance properties, we focused on…the memory processors security and connection settings.…Now let's take a look at the remaining settings.…And the first one we'll focus on here…are the database settings.…Now again, these are specific for the data…that we're storing on this instance of SQL server.…Our first option is the Default index fill factor.…And in order to understand how this applies to the data…and how it impacts our SQL server, we need to understand…how SQL server stores the data.…

Data is stored on the file system…in what are known as pages.…And by specifying our index fill factor…we determine how SQL server will make each page…when it comes to a new index, using our existing data.…So, in other words, the fill factor will affect performance…because SQL has to take time…to split the pages when they fill up.…So a page is only so large.…And typically it's around a 64 kilobyte size.…When that page fills up, SQL has to now create a new page…and move any new data that didn't get a chance…