SQL Server has default value for fill factor is Zero (0). The fill factor is implemented only when the index is created; it is not maintained after the index is created as data is added, deleted, or updated in the table. When creating an index, you can specify a fill factor to leave extra gaps and reserve a percentage of free space on each leaf level page of the index to accommodate future expansion in the storage of the table’s data and reduce the potential for page splits.
I like my fill factor to 90 (Why? I like it!) I use sp_configure to change the default fill factor for the SQL Server. sp_configure 'show advanced options', 1
GO RECONFIGURE GO sp_configure 'fill factor', 90
GO RECONFIGURE GO
Reference : Pinal Dave (http://blog.SQLAuthority.com) , BOL
Before doing any .Net coding in SQL Server you must enable the CLR. In SQL Server 2005, the CLR is OFF by default.
This is done in an effort to limit security vulnerabilities. Following is the script which will enable CLR.
EXEC sp_CONFIGURE 'show advanced options' , '1'; GO RECONFIGURE; GO EXEC sp_CONFIGURE 'clr enabled' , '1' GO RECONFIGURE; GO
The xp_cmdshell option is a server configuration option that enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. ---- To allow advanced options to be changed.
EXEC sp_configure ‘show advanced options’, 1
—- To update the currently configured value for advanced options.
—- To enable the feature.
EXEC sp_configure ‘xp_cmdshell’, 1
—- To update the currently configured value for this feature.