free on the database at least once. However, when this trace flag is enabled, this behavior becomes default without any query or database changes. In SQL Server 2016, when the bulk load operation causes a new page to be allocated, all of the rows sequentially filling that new page are minimally logged if all the other pre-requisites for minimal logging are met. Note: Starting with SQL Server 2012 (11.x) SP3 and online dating skriva en profil SQL Server 2014 (12.x) SP1 this behavior is controlled by the engine and trace flag 9024 has no effect. Scope : global or session or query 9485 Disables select permission for dbcc show_statistics. If a query does not get all the memory it needs, it spills data to tempdb, incurring additional I/O and potentially impacting query performance. Scope : global only 7471 Enables running multiple update statistics for different statistics on a single table concurrently. Scope : global or session 11023 Disables the use of the last persisted sample rate for all subsequent statistics update, where a sample rate is not specified explicitly as part of the update statistics statement. Some features, such as snapshot isolation and read committed snapshot, might not work. For more information, see this Microsoft Support article and Microsoft Support article. Scope : global or session 661 Disables the ghost record removal process.
Scope : global only 2453 Allows a table variable to trigger recompile when enough number of rows are changed. For example, to enable the 2528 trace flag globally, use dbcc traceon with the -1 argument: dbcc traceon (2528, -1). Rows inserted into existing pages (no new page allocation) to maintain index order are still fully logged, as are rows that are moved as a result of page splits during the load. Scope : global or session or query 2340 Causes SQL Server not to use a sort operation (batch sort) for optimized Nested Loops joins when generating a plan. Scope : global or session or query 9389 Enables additional dynamic memory grant for batch mode operators. Scope : global and session 9024 Converts a global log pool memory object into numa node partitioned memory object. This can help prevent disclosure of sensitive information. Scope: global only 6498 Enables more than one large query compilation to gain access to the big gateway when there is sufficient memory available. For more information, see Microsoft Support article Scope : global or session 9567 Enables compression of the data stream for Always On Availability Groups during automatic seeding. In SQL Server, an application role cannot access metadata outside its own database because application roles are not associated with a server-level principal. Refer to Configure the max worker threads Server Configuration Option for information on configuring the max worker threads server option.