[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] C2 security caching execution plans Query Analyzer 2nd calling stored procedures 2nd 3rd 4th 5th 6th cardinality of relationships cascading actions 2nd cascading deletions data integrity cascading updates data integrity CASE expressions 2nd 3rd 4th 5th case studies ACME Distributors 2nd 3rd 4th 5th 6th ACME Generators 2nd 3rd 4th Address book Application 2nd 3rd Boss Needs to Screen Data 2nd Dave's Video Rental Chain 2nd 3rd Doug's Car Wash and Donuts 2nd 3rd Emerald Sharp 2nd 3rd Joe's Burger and Malt Shop 2nd 3rd 4th Jones & Sons (database design) 2nd Lloyd's hospital (logical database design) 2nd 3rd 4th Menaubi Foods 2nd Porter Steak Company 2nd Western Furniture Ltd. 2nd 3rd case study exams tips for taking case study form exams MCP exams 2nd CaseStudio database design software CAST 2nd converting data 2nd certifications MCDBA (Microsoft Certified Database Administrator) MCP (Microsoft Certified Professional MCP+Internet (Microsoft Certified Professional+Internet) MCP+Site Building (Microsoft Certified Professional+Site Building) MCSD (Microsoft Certified Solution Developer) MCSE (Microsoft Certified Systems Engineer) MCSE+Internet (Microsoft Certified Systems Engineer+Internet) MCT (Microsoft Certified Trainer) overview practice requirements retired changing column headers during data retrieval 2nd 3rd indexes 2nd snapshot location 2nd changing. [See altering] char data type character data types 2nd character functions 2nd 3rd DATALENGTH 2nd SUBSTRING 2nd CHECK CHECK constraints 2nd 3rd 4th Check constraints CHECKSUM() function 2nd CHECKSUM_AGG() function 2nd CHECKSUM_BINARY() function checksums 2nd clauses FROM IN clauses 2nd ON DELETE ON UPDATE ORDER BY WHERE 2nd Client Network utility 2nd 3rd 4th Alias tab DB-Library tab General tab Network Libraries tab client/server model 2nd 3rd Internet applications 2nd one- tier systems third-party database connectivity three-tier systems 2nd two-tier systems 2nd very large database applications CLOSE clustered indexes 2nd 3rd 4th 5th 6th 7th 8th b-trees candidates for creating using code Primary Keys as COALESCE statement code creating clustered indexes creating nonclustered indexes 2nd COL LENGTH COL NAME collation sequences changing set sequences non-default COLLATIONPROPERTY collations column descriptors (tables) 2nd 3rd column headers changing during data retrieval 2nd 3rd column-level permissions COLUMNPROPERTY columns aliases XML 2nd properties of 2nd 3rd selecting in rows 2nd 3rd in views 2nd 3rd 4th 5th comma-delimited lists commands ALTER PROCEDURE BEGIN TRANSACTION CREATE INDEX DBCC SHOW STATISTICS DROP VIEW RAISERROR() RECONFIGURE SET TRANSACTION ISOLATION LEVEL sp adduser sp grantdbaccess sp grantlogin sp helptext STATS DATE TRIGGER NESTLEVEL UPDATE STATISTICS UPDATE STATISTICs commands. [See also stored procedures] comments 2nd 3rd COMMIT TRANSACTION 2nd 3rd common-sense study strategies comparison operators 2nd 3rd 4th 5th comparisons compatibility between locks 2nd composite indexes COMPUTE 2nd COMPUTE BY 2nd COMPUTE BY operator 2nd 3rd 4th versus CUBE and ROLLUP operators 2nd COMPUTE operator 2nd 3rd 4th versus CUBE and ROLLUP operators 2nd CONCAT_NULL_YIELDS_NULL database configuration option concurrency conditional statements IF ‰THEN ‰ELSE 2nd 3rd 4th 5th configuration functions 2nd 3rd configurations replication central publisher, multiple subscribers 2nd 3rd multiple publishers, multiple subscribers 2nd 3rd multiple publishers, single subscriber 2nd single publisher, remote distributor 2nd Configure Publishing and Distribution wizard configuring database options ANSI_NULL_DEFAULT ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT AUTO_CLOSE AUTO_CREATE_STATISTICS AUTO_SHRINK AUTO_UPDATE_STATISTICS BULK_LOGGED CONCAT_NULL_YIELDS_NULL CURSOR_CLOSE_ON_COMMIT CURSOR_DEFAULT LOCAL MULTI_USER NUMERIC_ROUNDABORT OFFLINE ONLINE QUOTED_IDENTIFIER READ_ONLY READ_WRITE RECOVERY FULL RECURSIVE_TRIGGERS RESTRICTED_USER setting 2nd SIMPLE SINGLE_USER TORN_PAGE_DETECTION WITH distribution server 2nd 3rd 4th server options Address Windowing Extension Enabled Affinity Mask Allow Updates C2 audit mode Cost Threshold for Parallelism Cursor Threshold Default Full-Text Language Default Language exam considerations Fill Factor Index Create Memory Lightweight Pooling Locks Max Degree of Parallelism Max Server Memory/Min Server Memory Max Text Repl Size Max Worker Threads Media Retention Min Memory Per Query Nested Triggers Network Packet Size Open Objects Priority Boost Query Governor Cost Limit Query Wait Reconfigure Recovery Interval Remote Access Remote Login Timeout Remote Proc Trans Remote Query Timeout Scan for Startup Process Set Working Set Size setting Two Digit Year Cutoff User Connections User Options confirming replication 2nd Consistency constraings indexes deleting constraining data modifications constraints 2nd defaults rules stored procedures 2nd views constraints CHECK 2nd 3rd 4th Check constraints creating 2nd data modification constraining 2nd Foreign Keys 2nd 3rd multiple servers Primary Keys 2nd 3rd constrants CONTAINS searches 2nd 3rd 4th 5th 6th CONTAINSTABLE searches 2nd controlling data access with views granting permissions and ownership chains 2nd 3rd modifications triggers 2nd convergence CONVERT 2nd 3rd 4th converting data CAST 2nd CONVERT 2nd 3rd 4th COUNT() function 2nd COUNT_BIG() function 2nd counter values optimizing OS configurations 2nd 3rd 4th CREATE DATABASE statement 2nd appropriate use COLLATE clause MAXSIZE option Create Database wizard CREATE FUNCTION CREATE INDEX command DROP EXISTING option CREATE INDEX statement indexed views creating 2nd 3rd CREATE INDEX statements 2nd 3rd 4th CREATE PROCEDURE statement 2nd 3rd 4th 5th CREATE TABLE altering indexes CREATE TRIGGER statement 2nd 3rd 4th 5th CREATE VIEW statement CREATE VIEW statements Create View Wizard creating views 2nd 3rd creating cursors 2nd 3rd 4th databases 2nd full-text indexes 2nd 3rd 4th indexed views 2nd 3rd indexes clustered indexes using code CREATE INDEX 2nd 3rd nonclustered indexes using code 2nd with Enterprise Manager 2nd with Index Tuning Wizard 2nd 3rd 4th 5th profile traces 2nd 3rd stored procedures 2nd 3rd 4th 5th 6th 7th with Enterprise Manager 2nd 3rd 4th traces 2nd triggers 2nd 3rd 4th INSERT trigger 2nd 3rd UPDATE trigger 2nd 3rd 4th user-defined functions 2nd 3rd 4th 5th inline user-defined functions 2nd 3rd scalar functions table-valued functions 2nd with Enterprise Manger 2nd 3rd 4th views 2nd 3rd by selecting columns by selecting columns with Enterprise Manager 2nd 3rd by selecting rows 2nd 3rd guidelines for 2nd 3rd partitioned views 2nd 3rd 4th with Create View Wizard 2nd 3rd with joins 2nd CREATTE FUNCTION statement CROSS JOIN statement 2nd cross joins 2nd CROSS JOIN statement 2nd cross-joins CUBE operator 2nd versus COMPUTE and COMPUTE BY operators 2nd Current Activity window 2nd 3rd optimizing SQL Server configurations lock information 2nd 3rd 4th process information 2nd 3rd Current Disk Queue Length counter CURRENT TIMESTAMP CURRENT USER cursor data type CURSOR STATUS return values CURSOR STATUS() function 2nd 3rd CURSOR_CLOSE_ON_COMMIT database configuration option CURSOR_DEFAULT LOCAL database configuration option cursors 2nd as returns comma-delimited lists creating 2nd 3rd 4th CURSOR STATUS() 2nd extensions T-SQL 2nd 3rd returned cursors rules for scrolling through 2nd stored procedures 2nd Transact-SQL extensions 2nd 3rd updates preventing updating 2nd updating data when to use 2nd 3rd |