What’s New in Configuring, Tuning, and Optimizing SQL Server Options
There are a few new configuration options in SQL Server 2008 R2. These new configuration options are user instance oriented (for SQL Server 2008 Express only), for FileStream, Compression, and are Access Check Cache options. However, you must be warned that there are options available that are not obsolete yet but have no effect (even if you set them). We identify them in this chapter as they come up.
SQL Server 2000 had a total of 36 options. With SQL Server 2005, the number of options nearly doubled, with a total of 64 (basic and advanced) active options. There are now 70 basic and advanced options in SQL Server 2008 R2. Not all are usable, and some apply only to certain ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
