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

D

E

F

G

H

I

K

L

M

N

O

P

Q

R

S

T

@font-face { font-family: 'livebook'; src:url('https://d19npu3b8zepp3.cloudfront.net/assets/fonts/livebook.eot?1.9.0'); src:url('https://d19npu3b8zepp3.cloudfront.net/assets/fonts/livebook.eot?1.9.0') format('embedded-opentype'), url('https://d19npu3b8zepp3.cloudfront.net/assets/fonts/livebook.woff?1.9.0') format('woff'), url('https://d19npu3b8zepp3.cloudfront.net/assets/fonts/livebook.ttf?1.9.0') format('truetype'), url('https://d19npu3b8zepp3.cloudfront.net/assets/fonts/livebook.svg?1.9.0') format('svg'); font-weight: normal; font-style: normal; }