[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] abbreviating PROCEDURE ABS() function accessing views 2nd 3rd 4th accessing heterogeneous data. [See heterogeneous data manipulation] ACID (Atomicity, Consistency, Isolation, Durability) ACME Distributors case study 2nd 3rd 4th 5th 6th ACME Generators case stury 2nd 3rd 4th active study strategies 2nd adaptive exams tips for taking 2nd adaptive-form exams MCP exams 2nd 3rd 4th 5th adding data through views 2nd 3rd logins administration Enterprise Manager utility advanced referential integrity options advantages of indexed views of replication 2nd of SQL Profiler of stored procedures of triggers 2nd of views 2nd 3rd 4th AFTER triggers 2nd 3rd 4th 5th DELETE INSERT 2nd 3rd UPDATE 2nd agents replication agents 2nd Distribution agent Log Reader agent 2nd Merge agent 2nd Queue Reader agent Snapshot agent 2nd aggregate functions 2nd 3rd data management aggregate functions 2nd 3rd statistical aggregate functions 2nd 3rd aggregates views enhancing 2nd alerts Enterprise Manager 2nd triggering performance counter alerts 2nd aliases 2nd columns XML 2nd ALL ALTER DATABASE statement ALTER FUNCTION statement ALTER PROCEDURE command ALTER TABLE statements altering indexes ALTER TRIGGER statement altering in Query Analyzer 2nd ALTER TRIGGER statements ALTER VIEW statement 2nd altering data stored procedures triggers 2nd ALTER TRIGGER in Query Analyzer 2nd with Enterprise Manager 2nd user -defined functions views dropping 2nd 3rd editing 2nd 3rd 4th renaming 2nd ALTERING DATABASE statement AND anonymous subscriptions ANSI_NULL_DEFAULT database configuration option ANSI_NULLS database configuration option ANSI_PADDING database configuration option ANSI_WARNINGS database configuration option APP NAME application log optimizing OS configurations 2nd application roles 2nd 3rd architecture of indexing 2nd arguments SELECT statement data retrieval ARITHABORT database configuration option arithmetic operators 2nd articles Publisher/Subscriber metaphor associate entities atomic values Atomicity attributes 2nd 3rd 4th auto-numbering attributes decomposing 2nd interdependent attributes naming conventions 2nd audits security audits 2nd AUTO option (FOR XML operator) 2nd 3rd auto-numbering attributes AUTO_CLOSE database configuration option AUTO_CREATE_STATISTICS database configuration option AUTO_SHRINK database configuration option AUTO_UPDATE_STATISTICS database configuration option automated optimization SQL Server Query Optimizer alerts Database Maintenance Plan Wizard jobs operators 2nd 3rd performance counter alerts 2nd automatic XML formatting extracting data 2nd 3rd AVG() function 2nd 3rd avoiding deadlocks SUBSTRING |