SQL Server DMVs in Action

Index

[A][B][C][D][E][F][G][H][I][K][L][M][N][O][P][Q][R][S][T][U][V][W]

A

ACID properties  atomic  consistent  durable  isolated active session ad hoc query, 2^nd, 3^rd aggregated results, 2^nd ASYNC_IO_COMPLETION, 2^nd ASYNC_NETWORK_IO automatically disable or drop unused indexes automatically implement missing indexes automatically rebuild/reorganize indexes automatically update a routine’s statistics, 2^nd average read/write times per file per database

B

batch BEGIN TRAN best practices  cache function values  consider replacing your IN clause  consider using data compression  consider using partitions  make your SQL simpler  Microsoft checklist  rewrite your queries  use temporary tables blocks Buffer Cache Hit Ratio

C

CAST, 2^nd, 3^rd catalog ...