Index
A
B
C
D
allocation structure consistency
referencing and referenced entities
principals (see Database principals)
aggregated query performance statistics
cached query plan performance statistics
cached query plan record counts
sys.dm_exec_requests, executable query capture
sys.dm_io_virtual_file_stats, I/O contention
sys.dm_os_wait_stats, bottleneck identification
E
F
G
H
I, J, K
L
Large tables and databases partition
ALTER PARTITION FUNCTION statements
ALTER PARTITION SCHEME statement
ALTER TABLE. . .SWITCH statement
DROP PARTITION FUNCTION statement
M
N
O
P
fn_builtin_permissions arguments
database-scoped securables (see Database-scoped securables)
Has_Perms_by_name system function
schema-scoped securables (see Schema-scoped securables)
Server Audit object (see Server Audit object)
server-scoped securables (see Server-scoped securables)
Q
aggregated performance statistics
cached query plan performance statistics
cached query plan record counts
executable query capture, sys.dm_exec_requests DMV
sp_control_plan_guide arguments
sp_create_plan_guide arguments
query execution plan estimation
query resource consumption limitation
classifier user-defined function
CREATE RESOURCE POOL arguments
CREATE WORKLOAD GROUP arguments
default and internal resource pools
sys.dm_resource_governor_resource_pools DMV
sys.dm_resource_governor_workload_groups DMV
sys.resource_governor_configuration catalog view
R
S
managing, modification and removing
primary Server Audit object settings
fn_get_audit_file table-valued function
AUTO_CREATE_STATISTICS database
AUTO_UPDATE_STATISTICS database
sys.server_principals system catalog view
query performance (see Query performance tuning)
T
inserted and deleted virtual tables
Production.ProductInventory table
U
SELECT * FROM HumanResources.Department
SHUTDOWN and DROP HumanResources.Department
V
W
subset of rows, total calculation
CUME_DIST and PERCENT_RANK functions
FIRST_VALUE and LAST_VALUE functions
PERCENTILE_CONT and PERCENTILE_DISC functions
X, Y, Z