O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Playing with Fill Factor

It is already discussed in the previous chapter, Chapter 9, Implementing Index, that when an index is being created, it stores data in the B-Tree format that has a root page, intermediate level, and leaf level. Leaf level, which is the bottom-most level, contains the actual data in a clustered index. Each data page is 8 KB in size.

When insertion/updation/deletion of data to/from a table happens, it tries to insert in the proper data page according to the record being inserted. For example, we have clustered index on SSN number. We are inserting a new row with the SSN number. SQL Server tries to insert that record in an appropriate data page. Suppose our SSN number starts with "2", then it will find the last page that ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required