Examples of using Trace flag in English and their translations into Romanian
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
-
Programming
When you turn on trace flag 652 in a user session,
If you turn on trace flag 652, SQL Server no longer brings database pages into the buffer pool before these database pages are consumed by the scans.
Incorrect use of this trace flag may cause additional physical reads when SQL Server executes plans that contain the Nested Loops operator.
You can use trace flag 836 to reduce the number of buffer descriptors that are allocated at startup in 32-bit Address Windowing Extensions(AWE) mode.
in a transactional replication if trace flag 1448 is enabled.
You can do this by using a query-level option to enable a trace flag for only a particular query.
these hotfixes are turned off by default, and a trace flag is required to enable the fix.
we do not recommend turning on trace flag 834.
In SQL Server 7.0, with trace flag 1807, if you use the DISK INIT backward-compatible syntax followed by a CREATE DATABASE statement with mapped syntax,
in SQL Server 7.0, with trace flag 1807, a CREATE DATABASE statement that is performed by using mapped
in SQL Server 7.0, with trace flag 1807, a CREATE DATABASE statement that is performed by using mapped
In SQL Server 7.0, without trace flag 1807, if you use the DISK INIT backward-compatible syntax followed by a CREATE DATABASE statement with either mapped
You can do this by enabling the trace flag in a batch(by using DBCC TRACEON command)
In the release version of SQL Server 2008 R2, the trace flag 4135 was inadvertently omitted from the list of trace flags that can be controlled by -T4199.
the SQL Server query processor team adopted a policy that any hotfix that could potentially affect the execution plan of a query must be controlled by a trace flag.
Microsoft SQL Server 7.0, with and without trace flag 1807.
in SQL Server 7.0, without trace flag 1807, if you execute a CREATE DATABASE statement with mapped
Note The trace flags that this article describes are advanced tuning techniques.
The following plan affecting trace flags are available in Microsoft SQL Server 2014.
You should consider using these trace flags only after you do more basic and routine optimizations.