Microsoft® SQL Server™ includes these new server configuration options:
| cost threshold for parallelism | query wait(s) |
| index create memory | remote proc trans |
| lightweight pooling | scan for startup procs |
| max degree of parallelism | time slice |
| min query memory per query | Unicode comparison style |
| max server memory | Unicode locale id |
| min server memory | extended memory size |
| query governor cost limit |
For more information, see Setting Configuration Options.
Microsoft SQL Server includes these new database options:
| autoclose | cursor close on commit |
| autoshrink | merge publish |
| ANSI nulls | quoted identifier |
| ANSI warnings | recursive triggers |
| concat null yields null | torn page detection |
For more information, see Setting Configuration Options.
sp_dbcmptlevel sets certain database behaviors to be compatible with a specified earlier version of SQL Server. For more information about compatibility levels and the effect of setting different compatibility levels, see sp_dbcmptlevel.