Glossary

ACID

An acronym for atomicity, consistency, isolation, and durability, the four properties required for a valid transaction.

Action, Notification Services

A T-SQL query used by Notification Services when firing a subscription rule.

activation stored procedure

A stored procedure used to read a Service Broker queue and process messages on arrival.

active/active cluster

Two active/passive clusters that share the same hardware, each acting as the standby server for the other.

active/passive cluster

See failover cluster.

ad hoc report

A report developed by a business user using a single data source and applying limited formatting.

Address Windowing Extension (AWE)

The software component that allows SQL Server to access more than 4 GB of memory.

aggregation ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.