SQL Server Attributes
Other
analysis-enforce-row-uniqueness
Use for analysis only! Enforce rows to be unique.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-delete-page-size-rows
Number of rows to delete per batch when bulk deleting.
- Default:
3000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-bytes
Approximate maximum size in bytes of batch when bulk inserting.
- Default:
10000000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-page-size-rows
Number of rows to insert per batch when bulk inserting.
- Default:
3000 - Set from: connection string, set statement, provider file
- Defined by: Shared
bulk-insert-timeout-sec
Number of seconds after which a bulk insert times out
- Default:
300 - Set from: connection string, set statement, provider file
- Defined by: SQL Server
command-timeout-sec
Number of seconds after which a command times out.
- Set from: connection string, set statement, provider file
connection-string-async-add
Should the 'Async' be added automatically to the connection string?
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Server
connection-string-async-value
Size of the Async to be added to the connection string
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Server
connection-string-multiple-active-result-sets-add
Should the 'MultipleActiveResultSets' be added automatically to the connection string?
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Server
connection-string-multiple-active-result-sets-value
Value of MultipleActiveResultSets to be added to the connection string
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Server
force-case-sensitive-identifiers
Consider identifiers as case-sensitive independent of the platform capabilities.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
forced-casing-identifiers
Forced casing of identifiers. Choose from: Unset, Lower, Upper and Mixed.
- Set from: connection string, set statement, provider file
- Defined by: Shared
invantive-sql-correct-invalid-date
Whether to correct dates considered invalid since they are before 01-01-1753. When nullable, they are removed. Otherwise they are replaced by 01-01-1753.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-forward-filters-to-data-containers
Whether to forward filters to data containers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-sql-shuffle-fetch-results-data-containers
Whether to shuffle results fetched from data containers.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
invantive-use-cache
Whether to cache the results of a query.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: SQL Engine V1
log-native-calls-to-disk
Registers native calls to data container backend as disk files.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
log-native-calls-to-trace
Log native calls to data container backend on the trace.
- Default:
False - Set from: connection string, set statement, provider file
- Defined by: Shared
max-url-length-accepted
The maximum accepted URL length before raising an error.
- Default:
8000 - Set from: connection string, set statement, provider file
- Defined by: Shared
max-url-length-desired
The maximum desired URL length.
- Default:
8000 - Set from: connection string, set statement, provider file
- Defined by: Shared
maximum-length-identifiers
Non-default maximum length in characters of identifier names.
- Set from: connection string, set statement, provider file
- Defined by: Shared
maximum-number-of-pooled-connections
Maximum number of concurrent pooled connections.
- Set from: connection string, set statement, provider file
maximum-sleep-acquire-pooled-connection-ms
Maximum time in ms to wait for acquiring a free connection from a pool of connections.
- Default:
30000 - Set from: connection string, set statement, provider file
maximum-sleep-acquire-unpooled-connection-ms
Maximum time in ms to wait for acquire a free connection when there is no connection pooling.
- Default:
60000 - Set from: connection string, set statement, provider file
minimum-command-timeout-sec
Minimum number of seconds after which a command times out.
- Default:
300 - Set from: connection string, set statement, provider file
minimum-connection-timeout-sec
Minimum connection timeout in seconds.
- Set from: connection string, set statement, provider file
on-close-sql
Native SQL statements to execute directly before close.
- Set from: connection string, set statement, provider file
on-open-sql
Native SQL statements to execute directly after open.
- Set from: connection string, set statement, provider file
open-connection-interval-sec
Delay between retries in milliseconds when login fails.
- Default:
500 - Set from: connection string, set statement, provider file
open-connection-retries
Maximum number of retries when login fails.
- Default:
2 - Set from: connection string, set statement, provider file
partition-slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a partition-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
partition-slot-based-rate-limit-slots
Number of slots per partition-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
pooled-connection-monitor-interval-sec
Minimum interval in seconds between two connection pool monitor activations.
- Default:
60 - Set from: connection string, set statement, provider file
pooled-connection-release-obsolete-interval-sec
Minimum interval in seconds between two tries to release obsolete connections from the connection pool when above the preferred number of connections.
- Default:
60 - Set from: connection string, set statement, provider file
pooled-connections-monitoring
Enable monitoring of connections of connection pool for automatic cleanup of obsolete connections.
- Default:
True - Set from: connection string, set statement, provider file
pre-request-delay-ms
Pre-request delay in milliseconds per request.
- Default:
0 - Set from: connection string, set statement, provider file
- Defined by: Shared
preferred-number-of-pooled-connections
Preferred number of concurrent pooled connections.
- Set from: connection string, set statement, provider file
prefix-bind-variable-in-list
Prefix for bind variables used in an IN-list
- Default:
i - Set from: connection string, set statement, provider file
prefix-bind-variable-normal
Prefix for bind variables used in all cases except in an IN-list
- Default:
w - Set from: connection string, set statement, provider file
prefix-renamed-columns
Prefix appended to columns whose names occur multiple times in the column list of a query
- Default:
column - Set from: connection string, set statement, provider file
requested-page-size
Preferred number of rows to exchange per round trip; only effective on limited platforms such as AFAS Online.
- Set from: connection string, set statement, provider file
- Defined by: Shared
requests-parallel-max
Maximum number of parallel data requests from individual partitions on the data container.
- Default:
32 - Set from: connection string, set statement, provider file
- Defined by: Shared
slot-based-rate-limit-length-ms
Total length in milliseconds across all slots of a slot-based rate limit.
- Default:
60000 - Set from: connection string, provider file
- Defined by: Shared
slot-based-rate-limit-slots
Number of slots of a slot-based rate limit. Null means no slot-based rate limit.
- Set from: connection string, provider file
- Defined by: Shared
standardize-identifiers
Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared
standardize-identifiers-casing
Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.
- Default:
True - Set from: connection string, set statement, provider file
- Defined by: Shared