Mastering SQL Server® 2008

Index

Note to the reader: Throughout this index boldfaced page numbers indicate primary discussions of a topic. Italicized page numbers indicate illustrations.

Symbols and Numbers

@ (at symbol)

for column as attribute, 199

for variables, 135

@@ERROR, 140–141

@@ROWCOUNT system function, 178, 182

@@TRANCOUNT global variable, 456

[ ] (square brackets), 114

32-bit processors

memory requirements, 13

physical addressable memory, 41

64-bit processors, memory, 13, 42

A

Active Data Objects, 504

Active Memory Grant Count counter, for resource pools, 480

Active Parallel Threads counter, for workload group monitoring, 477

Active Requests counter, for workload group monitoring, 477

Activity Monitor, 468–469

Locks by Object page, 469

Process Info page, 468 ...