MCSE Training Guide (70-229). Designing and Implementing Databases with MicrosoftR SQL ServerT 2000 Enterprise Edition
| [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]
parameters BCP 2nd BCP data import 2nd BULK INSERT command 2nd for BCP 2nd named parameters 2nd OPENROWSET function 2nd passing and returning to user -defined functions 2nd 3rd positional parameter passing PARSENAME partitioned views 2nd 3rd 4th 5th creating 2nd 3rd 4th federations guidelines for 2nd 3rd WHERE partitioning 2nd 3rd partitions creation strategies creation strategy multiple servers 2nd NTFS views 2nd 3rd passing parameters positional parameter passing to user-defined functions 2nd 3rd pathing XML PDQ Lite database design software performance optimizing with views performance counter alerts 2nd performing replays of traces 2nd PERMISSIONS 2nd permissions object permissions 2nd 3rd statement and object permissions 2nd 3rd statement permissions 2nd physical design (of databases) file placement RAID considerations 2nd 3rd sequential versus random access 2nd 3rd 4th system recoverability recoverability backup and disaster recovery operating system service properties 2nd 3rd recovery models 2nd 3rd 4th standby servers system and data recovery space requirements 2nd file growth strategies 2nd shrinking files system maintenance physical design of databases playing back traces 2nd requirements 2nd 3rd 4th 5th playing back. [See also replays] populating databases Bulk Copy program positional parameter passing Practice Test mode (PrepLogic practice test) buttons Practice Test mode (PrepLogic practice tests) starting a session pre-testing 2nd precedence UNION operator preparing XML documents 2nd PrepLogic contacting PrepLogic Exam Competency (PrepLogic practice tests) PrepLogic practice tests buttons customized tests Examination Score Report Flash Review mode starting a session installing interface design 2nd modes options Practice Test mode starting a session preconfigured tests PrepLogic Exam Competency Score reviewing the test software requirements timed tests uninstalling prerequisites for indexed views 2nd 3rd 4th preventing updates to cursors primary files default names PRIMARY KEY Primary Keys 2nd 3rd 4th 5th primary keys Primary Keys as clustered indexes constraints 2nd priming read PRINT statement 2nd proactive optimization SQL Query Optimizer alerts Database Maintenance Plan Wizard jobs operators 2nd 3rd performance counter alerts 2nd PROC procedural business logic stored procedures enforcing 2nd 3rd 4th 5th user-defined functions enforcing 2nd procedure cache process information Current Activity window 2nd 3rd profile traces defining 2nd 3rd 4th 5th to diagnose locking 2nd Profiler utility 2nd properties databases altering of columns 2nd 3rd operating system service 2nd 3rd properties. [See attributes] publications setting up 2nd 3rd 4th 5th 6th 7th Publisher Publisher/Subscriber metaphor 2nd articles Distributor partitioning 2nd Publisher Subscriber subscriptions Pubs database databases Pubs pulling subscriptions 2nd 3rd 4th
|