tailieunhanh - Microsoft SQL Server 2008 R2 Unleashed- P234

Microsoft SQL Server 2008 R2 Unleashed- P234: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 | 2294 CHAPTER 55 Configuring Tuning and Optimizing SQL Server Options then explicitly allow cross-database ownership chaining using the SET clause of the ALTER DATABASE statement. cursor threshold Type Advanced Default value -1 The cursor threshold option allows you to specify when SQL Server should generate a cursor result set asynchronously. If the optimizer estimates that the number of rows returned by the cursor is greater than the value specified by this parameter it generates the result set asynchronously. The optimizer makes this decision based on the distribution statistics for each table that is participating in the join in the cursor. To determine the optimal value for this parameter you need to make sure that statistics are up-to-date by running update statistics for the tables used in the cursors. By default SQL Server generates a cursor result set synchronously. If you are using a fair number of cursors that return a large number of result sets setting this value to a higher value results in better performance. Setting this value to 0 forces SQL Server to always generate a cursor result set asynchronously. The following is an example of this option exec sp_configure cursor threshold 100000 go RECONFIGURE go The following is a general recommendation of what to specify based on the different application types you are running OLTP Use the default value -1. Data warehouse A data warehousing environment is the largest potential user of this option due to the high volume of result rows returned by applications using data warehouses. Setting this value to 100 000 is a good starting point. OLAP Use the default value -1. Mixed Use the default value -1. default full-text language Type Advanced Default value 1033 The default full-text language option is used to specify a default language value for full-text indexed columns. Linguistic analysis is performed on all data that is full-text indexed and is strictly dependent on the language of the data. The default .