About
Test Org Zubair Masoodi
But nothing is free, especially in SQL Server. The downside to setting the fill factor is that, because of the white space requirement, the index requires more space on the disk than it actually needs. If your index should be 10 MB, a fill factor of 10% means your index will actually be about 11 MB.
The fill factor setting tells SQL Server to leave a certain amount of white space in the data page when you are building, rebuilding or defragmenting an index. If you leave this space free when the index is created, SQL Server can reduce or eliminate index fragmentation by using the white space to put new values in while new records are added or as existing records are updated in the index. However, SQL Server doesn’t maintain this amount of free space on its own. Moving the data around to open up this white space requires the indexes to be rebuilt or reorganized on a regular basis.
Teaching Preferences
Online Teaching
Face to Face Teaching
Offers free trial classes
Subjects or
exams this organization teaches
CAT
Achievement:
The fill factor setting tells SQL Server to leave a certain amount of white space in the data page when you are building, rebuilding or defragmenting an index. If you leave this space free when the index is created, SQL Server can reduce or eliminate index fragmentation by using the white space to put new values in while new records are added or as existing records are updated in the index. However, SQL Server doesn’t maintain this amount of free space on its own. Moving the data around to open up this white space requires the indexes to be rebuilt or reorganized on a regular basis.
Language of Instruction:
English
Dance (1st - 4th Grade)
Language of Instruction:
English
dasdasda, asd