Microsoft® SQL Server® 2012 Bible

Part V Enterprise Data Management IN THIS PART Chapter 19 Confi guring SQL Server Chapter 20 Policy Based Management Chapter 21 ...

c19.indd 468c19.indd 468 7/30/2012 5:42:42 PM7/30/2012 5:42:42 PM http://www.it-ebooks.info ...

469 CHAPTER 19 Confi guring SQL Server IN THIS CHAPTER Making Sense of SQL Server Confi guration Confi guring the Server-Level C ...

470 Part V: Enterprise Data Management To view miscellaneous information about the computer system while confi guring SQL Server ...

471 Chapter 19: Confi guring SQL Server 19 Confi guring the Server The server-level confi guration options control server-wide s ...

472 Part V: Enterprise Data Management Result: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) ...

473 Chapter 19: Confi guring SQL Server 19 Result: name minimum maximum config_value run_value --------------------------- ----- ...

474 Part V: Enterprise Data Management 10 LegalCopyright NULL Microsoft Corp. All rights reserved. 11 LegalTrademarks NULL Micro ...

475 Chapter 19: Confi guring SQL Server 19 FIGURE 19-2 Use Management Studio’s Database Properties Options tab to confi gure the ...

476 Part V: Enterprise Data Management The connection-level options are typically confi gured by means of the SET command. The f ...

477 Chapter 19: Confi guring SQL Server 19 Surface Area Confi guration Facets In SQL Server 2005 you were introduced to the Surf ...

478 Part V: Enterprise Data Management Displaying the Advanced Options As with many operations, displaying advanced options can ...

479 Chapter 19: Confi guring SQL Server 19 cost threshold for parallelism 0 32767 5 5 cross db ownership chaining 0 1 0 0 cursor ...

480 Part V: Enterprise Data Management SQL Mail XPs 0 1 0 0 transform noise words 0 1 0 0 two digit year cutoff 1753 9999 2049 2 ...

481 Chapter 19: Confi guring SQL Server 19 FIGURE 19-5 Add startup parameters to the SQL Server service to change its behavior. ...

482 Part V: Enterprise Data Management ■ (^) -c: Starts SQL Server so that it is not running as a Windows service. ■ (^) -x: Ena ...

483 Chapter 19: Confi guring SQL Server 19 to execute this query at startup, it pushes the data into memory for quick access for ...

484 Part V: Enterprise Data Management The memory-confi guration properties, listed in Table 19-2, control how SQL Server uses a ...

485 Chapter 19: Confi guring SQL Server 19 allocate the minimum amount of memory at startup. The minimum simply means that when ...

486 Part V: Enterprise Data Management Fixed Memory Instead of dynamically consuming memory, you can confi gure SQL Server to re ...