Index C


[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  



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