A

Index

[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]

ABS() function
access (data)
     concurrency 2nd 3rd
     exam prep questions 2nd 3rd 4th 5th 6th
     indexes 2nd
         clustered 2nd
         covering 2nd
         dropping 2nd
         full-text 2nd
         Index Tuning Wizard 2nd
         indexed views 2nd
         nonclustered 2nd 3rd
         rebuilding 2nd 3rd
         strategies 2nd
         what not to index 2nd 3rd
         what to index 2nd
     locks 2nd 3rd
         contention 2nd
         controlling lock behavior 2nd 3rd
         exclusive locks
         granularity
         shared locks
         transaction isolation levels 2nd
     partitioned views 2nd
         indexing 2nd
     stored procedures 2nd 3rd 4th
         recompilation 2nd
         web applications and 2nd
     transactions 2nd 3rd
         atomicity
         beginning 2nd
         consistency
         durability
         isolation
         isolation levels 2nd
         rolling back 2nd
ACID properties (transactions) 2nd
Address Windowing Extension (AWE)
Affinity Mask option (server properties)
AFTER triggers 2nd 3rd
aggregate functions 2nd
     AVG()
     COUNT()
     COUNT_BIG()
     MAX()
     MIN()
     SUM()
alerts 2nd 3rd
     definition of
     event alerts 2nd
     performance counter alerts 2nd
Allow Nulls descriptor (columns)
Allow Updates option (server properties)
ALTER DATABASE statement 2nd
ALTER TRIGGER statement 2nd
ALTER VIEW statement
Analysis Services
analyzing data 2nd
ANSI_NULL_DEFAULT option (databases)
ANSI_NULLS option (databases)
ANSI_PADDING option (databases)
ANSI_WARNINGS option (databases)
answers to practice exam one
     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th
     answer key 2nd
answers to practice exam two
     answer explanations 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th
     answer key 2nd
application logs 2nd
application roles 2nd
ARITHABORT option (databases)
arithmetic operators
articles
ASCII() function
associate entities 2nd
associative entities
asterisk (*)
at symbol (@)
atomic value
atomicity (transactions)
attributes
     decomposing 2nd 3rd
     defining 2nd 3rd
     definition of
     foreign keys 2nd
     identifiers
     key attributes 2nd
     primary keys 2nd
     surrogate keys
audits 2nd
     C2 security audits 2nd
     SQL Profiler security audits 2nd
auto options
     AUTO_CLOSE 2nd
     AUTO_CREATE_STATISTICS
     AUTO_SHRINK
     AUTO_UPDATE_STATISTICS
AUTO_CLOSE option (databases) 2nd
AUTO_CREATE_STATISTICS option (databases)
AUTO_SHRINK option (databases)
AUTO_UPDATE_STATISTICS option (databases)
automation 2nd 3rd 4th
     alerts 2nd
         event alerts 2nd
         performance counter alerts 2nd
     jobs 2nd
     operators 2nd
autonomy (site) 2nd
averages, returning
AVG() function
AWE (Address Windowing Extension)
AWE Enabled option (server properties)