There is always more than one way to do one thing in any programming languages. In SQL Server there is always more than one way to achieve same result set. It is quite often I see that developers write subqueries in place of joins or joins in place subqueries.
SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
As the title is very clear what this post is about I will not write long description. I have listed definition of FILLFACTOR from BOL here.


