SQL Server initialization parameters
The default settings for the SQL Server database managment system work well with ArcSDE.
If you want to make any changes to the default SQL Server settings, be sure to read about each setting in the SQL Server books online to fully understand what it is you are changing.
8/19/2013