Microsoft SQL Server 2008 R2 Unleashed- P241

Microsoft SQL Server 2008 R2 Unleashed- P241:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005. | 2364 configuration options affinity mask CD 2287-CD 2288 Agent XPCD 2289 awe enabled CD 2289-CD 2291 backup compression default CD 2291 blocked process threshold CD 2291 c2 audit mode CD 2291-CD 2292 clr enabled CD 2292 common criteria compliance enabled CD 2292 cost threshold for parallelism CD 2293 cross db ownership chaining CD 2293 cursor threshold CD 2294 default full-text language CD 2294-CD 2296 default language CD 2296-CD 2298 EKM provider enabled CD 2298 filestream_access_level CD 2299 fill factor CD 2299-CD 2300 fixing incorrect option settings CD 2283 in-doubt xact resolution CD 2300 index create memory CD 2300 lightweight pooling CD 2301 locks CD 2301-CD 2302 max degree of parallelism CD 2302 max server memory CD 2302-CD 2303 max text repl size CD 2304 max worker threads CD 2305 min memory per query CD 2306 min server memory CD 2302-CD 2303 miscellaneous options CD 2316 nested triggers CD 2306 network packet size CD 2306-CD 2307 new features CD 2274 obsolete configuration options CD 2283-CD 2284 optimize for ad hoc workloads CD 2307-CD 2308 overview CD 2275-CD 2283 parallelism CD 2293 PH_timeout CD 2308 priority boost CD 2308-CD 2309 query governor cost limit CD 2309-CD 2310 query wait CD 2310 recovery interval CD 2310-CD 2311 remote admin connections CD 2311 remote login timeout CD 2311 remote proc trans CD 2312 remote query timeout CD 2312-CD 2313 scan for startup procs CD 2313 self-configuring options CD 2276 setting with SSMS CD 2283 show advanced options CD 2313 user connections CD 2313-CD 2314 user options CD 2315-CD 2316 XP-related configuration options CD 2316 configuration phase dtexec 2137 file 212-216 configuring. See also configuration options SQL Server 2008 clients 274 connection encryption 278-279 new features 263-264 SSCM 275-277 Data Collector 1433-1437 Database Mail mail profiles and accounts 429-432 overview 428-429 systemwide mail settings 433 testing setup 433-434 database mirroring client setup and .