Click or drag to resize

DynamicQueryEngine Fields

The DynamicQueryEngine type exposes the following members.

Fields
  NameDescription
Public fieldStatic memberArithAbortOn
Flag to signal the DQE to generate SET ARITHABORT ON statements prior to INSERT, DELETE and UPDATE Queries. Keep this flag to false in normal usage, but set it to true if you need to write into a table which is part of an indexed view. It will not affect normal inserts/updates that much, leaving it on is not harmful. Please consult SqlServer's Books online for more details on SET ARITHABORT ON. After each statement the setting is turned off if it has been turned on prior to that statement.
Public fieldStatic memberUseNoLockHintOnSelects
Flag to signal the DQE to tell the SqlServerSpecificCreator to create WITH NOLOCK hints on table references in select queries for FROM clauses. WITH NOLOCK is not recommended though in high volume databases with a lot of rows, it can be a lot of blocking can occur because SqlServer forces readers to block writers and vice versa. Please consult the SqlServer's Book online for more information about this hint and also the downsides for using it. The setting is global and for all select queries. Default is false and it should only be set to true in those situations in which no other option is available.
Top
See Also