Max number parallellisme:
default: use all processors, othtewise fill in the number of processors to be used.
Default: 0. Windows regelt the assignment over the different CPU's.
When a number is filled in SQL uses this processor for his threads.
switched large memory amounts between SQL-server and the OS.
specify the max period an query can run.
default is off
Optimize for Ad_Hoc workloads:
If you use the functions openrowset or opendatasource to open a remote OLEDB datasource
this option must be enabled