Archives: June 2011

In my last post, I had explained what could be the best value of Fill Factor for the indexes in SQL Server and had promised to show a handy way to ReBuild all the indexes including the ones created on the Indexed Views.

IntroductionWhen an index is created or rebuilt, the fill-factor value determines the percentage of space on each leaf-level page to be filled with data, reserving the remainder on each page as free space for future growth. For example, specifying a fill-factor value of 80 means that 20 percent of… Read more

In my last blog about Tally Tables, we talked about the use of
recursive CTEs to generate Tally Tables. Following that, someone quickly asked
me to generate a Tally Table for integers starting from 1 to 150 as when he
tried the way explained in my last post, the…Read more