Microsoft® SQL Server® 2012 Bible

507 Chapter 19: Confi guring SQL Server 19 ■ (^) If you want to allow remote clients to access the FILESTREAM data stored on thi ...

508 Part V: Enterprise Data Management In Management Studio, you can set the default full-text language confi guration option by ...

509 Chapter 19: Confi guring SQL Server 19 of 2049. If the two-digit year falls on or after the fi rst value (default 50 ), then ...

510 Part V: Enterprise Data Management Confi guring Database Auto Options Five database-confi guration options determine the aut ...

511 Chapter 19: Confi guring SQL Server 19 Best Practice Do not set auto_close ON for production SQL Server databases. There may ...

512 Part V: Enterprise Data Management Auto Update Statistics SQL Server’s cost-based query optimizer uses statistics to choose ...

513 Chapter 19: Confi guring SQL Server 19 Cursor-Confi guration Properties The cursor-confi guration properties, as shown in Ta ...

514 Part V: Enterprise Data Management Cursor Close on Commit The cursor close on commit property closes an open cursor after a ...

515 Chapter 19: Confi guring SQL Server 19 TABLE 19-9 SQL ANSI–Confi guration Properties Property Level* Graphic Control Code Op ...

516 Part V: Enterprise Data Management In Management Studio, the ANSI settings can be enabled (ON) at the following levels: ■ Se ...

517 Chapter 19: Confi guring SQL Server 19 If the ANSI_NULL_DEFAULT option is not set at the database level, you can also set th ...

518 Part V: Enterprise Data Management ANSI Padding The ANSI_PADDING connection setting affects only newly created columns. When ...

519 Chapter 19: Confi guring SQL Server 19 Arithmetic Abort The ARITHABORT connection setting can handle query termination if an ...

520 Part V: Enterprise Data Management Numeric Round Abort The NUMERIC_ROUNDABORT connection setting controls the behavior of nu ...

521 Chapter 19: Confi guring SQL Server 19 Use Quoted Identifier The QUOTED_IDENTIFIER setting enables you to refer to an identi ...

522 Part V: Enterprise Data Management Nested Triggers A trigger is a small stored procedure executed on an insert, update, or d ...

523 Chapter 19: Confi guring SQL Server 19 TABLE 19-12 Database-State-Confi guration Properties Property Level* Graphic Control ...

524 Part V: Enterprise Data Management You may encounter a situation in which the database is inaccessible and you do not have a ...

525 Chapter 19: Confi guring SQL Server 19 To set the compatibility level of the AdventureWorks2012 sample database to 110 (SQL ...

526 Part V: Enterprise Data Management ■ (^) Bulk-Logged: The transaction log contains all DML operations, but bulk insert opera ...