2.8. SERVER, DATABASE AND SESSION SETTINGS
Server configuration settings, database configuration settings and session (or connection) property settings in some cases interact and in some cases are disjointed. Because some settings interact, I have found it less confusing to consider them all together.
2.8.1. Settings Overview
Most people can live a long and happy life without delving into the morass of these settings. Microsoft has done an excellent job of designing the database engine to set appropriate default values and of self-tuning to keep performance at a peak for most applications. Nonetheless, I think they need to clean up the interfaces for setting and reading the settings (see Author's Opinion below).
Generally speaking, server settings ...
Get Transact-SQL Desk Reference 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.
