Index E

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

editing
       views   2nd   3rd   4th  
editing.   [See also altering]
elements (XML)  
ELSE statements   2nd  
EMC (Enterprise Manager Console) utility  
       configuring   2nd  
enabling
       replication   2nd  
encryption   2nd   3rd  
ENCRYPTION   2nd  
encryption  
END
       statement blocks   2nd   3rd  
END keyword
       in CASE expressions  
enforcing
       procedural business functions
               with user -defined functions   2nd  
       procedural business logic
               with stored procedures   2nd   3rd   4th   5th  
       referential and data integrity
               triggers   2nd   3rd   4th   5th  
enhancing
       views  
               aggregates   2nd  
               joins   2nd   3rd  
               with views   2nd  
Enterprise Managaer
       user-defined functions
               creating   2nd   3rd   4th  
Enterprise Manager
       alerts   2nd  
               triggering  
       altering database properties  
       configuring publishing and distribution mechanisms   2nd   3rd   4th  
       creating databases  
       creating linked servers   2nd   3rd   4th   5th  
       creating views
               by selecting columns   2nd   3rd  
        demographics
               initializing  
       indexes
               creating   2nd  
       jobs
               descriptions  
       lock behavior
               viewing  
        publications
               setting up   2nd   3rd   4th   5th   6th   7th  
       stored procedures
               creating   2nd   3rd   4th  
       subscriptions
               pulling   2nd   3rd   4th  
       triggers
               altering   2nd  
               viewing   2nd  
       UPDATE trigger
               creating   2nd   3rd   4th  
       viewing SQL Server debugging information  
Enterprise Manager Console (EMC) utility  
       configuring   2nd  
Enterprise Manager utility   2nd   3rd  
       registering servers   2nd  
entities   2nd   3rd   4th   5th  
       associate entities  
       attributes.   [See attributes]
       naming conventions   2nd  
entity integrity   2nd   3rd   4th   5th  
entity keys   2nd  
       Foreign Keys  
       Primary Keys   2nd   3rd  
entity-relationship diagrams (ERDs)  
Entity-Relationship Model.   [See ER Model]
ER (Entity-Relationship) Model   2nd   3rd  
       attributes   2nd   3rd   4th  
                decomposing   2nd  
               naming conventions   2nd  
       entities   2nd   3rd   4th   5th  
       entity keys   2nd  
               Foreign Keys  
               Primary Keys   2nd   3rd  
       relationships   2nd   3rd  
               implementing   2nd   3rd  
               many-to-many  
               one-to-many  
               one-to-one  
ER modeling   2nd  
ERDs (entity-relationship diagrams)  
error handling  
       stored procedures   2nd   3rd   4th   5th   6th  
       user-defined functions   2nd   3rd   4th  
error logs   2nd   3rd  
error number  
error severity  
errors
       raising   2nd  
       system error messages   2nd  
       user error messages   2nd  
       user-defined errors
               raising  
ERWIN
       databse design software  
event classes  
Event Viewer
       optimizing OS configurations   2nd   3rd  
exam format
       MCP exams  
               adaptive-form   2nd   3rd   4th   5th  
               case study form   2nd  
               fixed-form   2nd  
exam prep tips   2nd   3rd  
       MCP exam   2nd  
exam simulation  
exam-taking tips   2nd  
       adaptive exams   2nd  
       case study exams  
       fixed-form exams   2nd  
Examination Score Report
       test scores  
Examination Score Report (PrepLogic practice tests)  
exams
       practice  
               customized  
               displaying scores  
               installing  
               modes  
               preconfigured  
               reviewing the exam  
               timed  
               uninstalling  
       retake policy   2nd  
       scheduling  
exclusive locks  
EXEC statement
       stored procedures   2nd   3rd   4th  
executing
       full-text searches   2nd  
               with FREETEXT  
execution plans
       Query Analyzer   2nd   3rd  
               caching and sharing   2nd  
               hints   2nd   3rd  
               reading   2nd   3rd  
EXISTS() function  
EXPLICIT option (FOR XML operator)   2nd   3rd   4th  
explicitly creating XML formatting
       extracting data   2nd   3rd   4th  
exporting/importing data   2nd  
       with BCP   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
       with BULK INSERT statement   2nd   3rd  
       with DTS (Data Transformation Services)   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
eXtensible Markup Languages.   [See XML]
extensions
       to cursors
               Transact-SQL   2nd   3rd  
extensions (files)  
extents  
extracting data
       in XML format   2nd  
               automatic formatting   2nd   3rd  
               explicitly creating formatting   2nd   3rd   4th  
               minimal formatting   2nd