admin, Author at SQLServerGeeks

SQL Server Resource Database

March 27, 2011December 18, 2014 - by admin - 9 Comments.

Resource Database In this Post I am going to take you through the 5th system database which is available right from SQL Server 2005. As we know till SQL Server 2000 …

SQL Server

SQL Server Index Fill Factor

March 24, 2011December 18, 2014 - by admin - 4 Comments.

Index Fill Factor FILLFACTOR, The FILLFACTOR option allows you to allocate a percentage (0 to 100) of free space on the leaf-level index pages to reduce page splitting. This option is …