Mcp Notes

File Factor, view, File factor –it is seldom necessary to specify a fill factor when you create a index. the option is provided for fine tuning performance .It is useful when u are creating a new index on a table with existing data and particularly when you accurately predict the future changes in that data . FILLFACTOR is specified as a percentage and it indicates how full sqlserver should make the leaf level of each index page during index creation .AS a table is updated and index is fills.sql server must split the index page to make rooms for new rows. which is require time for update intensive tables a properly chosen fill factor value yields better update performance than an improper fill factor value .the default fill factor is usually is usually efficient for most database usage. an explicit fill factor setting applies only when the index is first created sql server does not dynamically keep the specified percentage of empty space in the pages .the default fill factor is 80. Cluster index and non-clustered index The with recompile option will force a recompilation of the execution plan every time the stored procedure run.