C2 Audit Mode: Configures the server to record both failed and successful attempts to access statements and objects.
Fill Factor: Specifies how full SQL Server 2008 should make each page when it creates a new index using existing data.
Min and Max Server Memory: Reconfigures the amount of memory (in megabytes) in the buffer pool used by an instance of SQL Server.
Nested triggers: Controls whether an AFTER trigger can cascade; that is, perform an action that initiates another trigger, which initiates another trigger, and so on.
Query Governor Cost Limit: Specifies an upper limit on the time period in which a query can run.
Query Wait: Specifies the time in seconds (from 0 through 2147483647) that a query waits for resources before timing out. If the default value of -1 is used, the time-out is calculated as 25 times the estimated query cost.
CLR Integration: Supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support.
Fill Factor: Specifies how full SQL Server 2008 should make each page when it creates a new index using existing data.
Min and Max Server Memory: Reconfigures the amount of memory (in megabytes) in the buffer pool used by an instance of SQL Server.
Nested triggers: Controls whether an AFTER trigger can cascade; that is, perform an action that initiates another trigger, which initiates another trigger, and so on.
Query Governor Cost Limit: Specifies an upper limit on the time period in which a query can run.
Query Wait: Specifies the time in seconds (from 0 through 2147483647) that a query waits for resources before timing out. If the default value of -1 is used, the time-out is calculated as 25 times the estimated query cost.
CLR Integration: Supplies managed code with services such as cross-language integration, code access security, object lifetime management, and debugging and profiling support.
No comments:
Post a Comment