Index A


[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  



MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
ISBN: N/A
EAN: N/A
Year: 2003
Pages: 228

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net