Index D


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

data
       adding through views   2nd   3rd  
       altering  
       constraining modifications  
               constraints   2nd  
               defaults  
               rules  
               stored procedures   2nd  
               views  
       controlling access to
               granting permissions and ownership chains   2nd   3rd  
       deleting   2nd   3rd  
       displaying
               with SELECT   2nd  
       filtering   2nd   3rd  
               BETWEEN  
               IN  
               LIKE   2nd   3rd   4th  
               operators.   [See operators]
               returning TOP rows   2nd   3rd  
               selecting rows based on null values   2nd  
               with stored procedures   2nd   3rd  
       formatting   2nd  
               CAST   2nd   3rd   4th  
               CONVERT   2nd   3rd   4th  
       inserting  
               with SELECT  
       inserting into tables   2nd   3rd  
               INSERT EXECUTE   2nd  
               INSERT INTO SELECT   2nd  
               SELECT INTO   2nd  
       modifying
               SELECT   2nd   3rd  
       ordering into lists   2nd  
       summarizing   2nd  
               character functions.   [See character functions]
               date functions.   [See date functions]
               mathematical functions   2nd   3rd  
               system functions.   [See system functions]
       updating   2nd   3rd  
       updating with cursors  
        user -defined functions
               filtering   2nd   3rd   4th  
data cache  
Data Columns tab  
data dictionaries   2nd  
data encryption   2nd   3rd  
data extraction.   [See extracting data]
data filtering.   [See filtering data]
data grouping.   [See grouping data]
data import/export.   [See importing/exporting data]
data integrity   2nd   3rd  
       data types   2nd   3rd  
               binary data types   2nd  
               character data types   2nd  
               numeric data types   2nd   3rd  
               specialty data types   2nd   3rd  
               user-defined data types   2nd  
       domain integrity   2nd   3rd   4th  
       entity integrity   2nd   3rd   4th  
       referential integrity   2nd   3rd  
       triggers
               enforcing   2nd   3rd   4th   5th  
data integrity options  
data management aggregate functions   2nd   3rd  
data manipulation
       managing with transactions   2nd   3rd  
data model
       filtering data   2nd   3rd  
data retrieval  
       FROM   2nd   3rd   4th  
       ORDER   2nd   3rd  
       SELECT   2nd  
       SELECT statement   2nd   3rd   4th   5th  
               arguments  
               changing column headers   2nd   3rd  
               DISTINCT   2nd   3rd  
               string concatenation   2nd  
       T-SQL  
       WHERE   2nd  
data storage
       extents  
       indexing   2nd   3rd  
data summaries.   [See summarizing data]
Data Transformation Services (DTS)   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
Data Transformation Services Import/Export wizard  
data types   2nd   3rd   4th   5th   6th  
       bigint  
       binary data types   2nd  
       character data types   2nd  
       new  
       numeric data types   2nd   3rd  
       specialty data types   2nd   3rd  
       sql variant  
       table  
       user-defined data types   2nd  
database
       creating
               using the Model database as a template  
Database Console Command.   [See DBCC]
database design
       domain integrity  
       entity integrity  
       ER modeling   2nd  
       foreign keys  
       logical database design.   [See logical database design]
       many-to-many relationship  
       one-to-many relationship  
       one-to-one relationship  
       primary keys  
       referential integrity   2nd  
       SQL Server data types   2nd   3rd  
       UNION operators   2nd  
database diagrams  
database engine
       features  
Database Maintenance Plan Wizard  
database objects
       altering  
       creating and altering  
       tables  
               CHECK constraints   2nd   3rd   4th  
               column descriptors   2nd   3rd  
               creating   2nd  
               indexes   2nd  
database roles  
DATABASEPROPERTY  
DATABASEPROPERTYEX  
databases  
       altering   2nd  
       configuration settings  
               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  
       creating   2nd   3rd   4th   5th   6th   7th  
               Create Database wizard  
               Enterprise Manager  
               non-default collation sequences  
               T-SQL code  
       database diagrams  
       database roles  
       default  
       defined   2nd  
       fields  
       filegroups  
               backup and restore considerations   2nd  
               creating  
               placement in physical design   2nd   3rd   4th   5th   6th   7th  
               placement of objects   2nd   3rd   4th  
       files  
               creating  
               extensions  
               log files  
               primary files  
       integrity options   2nd   3rd   4th  
       management
               Enterprise Manager utility  
       Master  
       Model   2nd  
               storing common objects and code  
       Msdb  
       Northwind  
       objects   2nd   3rd  
       physical design  
               file placement   2nd   3rd   4th   5th   6th   7th  
               recoverability   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
               space requirements   2nd   3rd   4th   5th  
               system maintenance  
       populating
               Bulk Copy program  
       properties
               altering  
       records  
       relational  
       tables  
       Tempdb  
DATALENGTH   2nd  
DATALENGTH() function  
datatypes  
date functions   2nd   3rd  
       DATEADD   2nd   3rd  
       DATEDIFF   2nd  
       DATENAME   2nd  
       DATEPART   2nd  
       GETDATE   2nd  
DATEADD function   2nd   3rd  
DATEDIFF function   2nd  
DATENAME function   2nd  
DATEPART function   2nd  
datetime data type  
DB ID  
DB NAME  
DB-Library  
       future implementation  
       upgrading  
DBCC
       maintenance operations   2nd  
       miscellaneous operations   2nd  
       status operations   2nd  
       validation operations   2nd  
DBCC (Database Console Command)  
DBCC CHECKALLOC  
DBCC CHECKCATALOG  
DBCC CHECKCONSTRAINTS  
DBCC CHECKDB   2nd   3rd  
DBCC CHECKFILEGROUP  
DBCC CHECKIDENT  
DBCC CHECKTABLE  
DBCC DBREINDEX   2nd  
DBCC DBREINDEX statement  
DBCC DBREPAIR  
DBCC dllname (FREE)  
DBCC HELP  
DBCC INDEXDEFRAG   2nd  
DBCC INDEXDEFRAG command  
DBCC INPUTBUFFER  
DBCC NEWALLOC  
DBCC OPENTRAN   2nd  
DBCC OUTPUTBUFFER  
DBCC PINTABLE  
DBCC PROCCACHE  
DBCC ROWLOCK  
DBCC SHOW STATISTICS  
DBCC SHOW STATISTICS command  
DBCC SHOWCONTING  
DBCC SHRINKDATABASE  
DBCC SHRINKFILE  
DBCC SQLPERF  
DBCC statement
       parameters
               SHRINKDATABASE  
               SHRINKFILE  
DBCC TRACEOFF  
DBCC TRACEON  
DBCC TRACESTATUS  
DBCC UNPINTABLE  
DBCC UPDATEUSAGE  
DBCC USEROPTIONS  
deadlocks   2nd   3rd  
       avoiding  
DEALLOCATE  
debugging information
       viewing with Enterprise Manager  
DECLARE CURSOR  
DECLARE CURSOR STATEMENT  
declaring
        variables   2nd  
decomposing
       attributes   2nd  
default databases  
defaults   2nd   3rd  
       data modification
               constraining  
definable events  
DELCARE CURSOR  
DELETE statement  
DELETE statements  
DELETE triggers  
deleting
       data   2nd   3rd  
       rows
               through views   2nd   3rd   4th  
deleting.   [See also dropping]
demographics
       Enterprise Manager
               initializing  
denormalization   2nd   3rd   4th  
derived tables   2nd   3rd  
descriptions
       jobs
               Enterprise Manager  
design
       physical  
designing
       transactions   2nd  
designing databases.   [See database design]
determinism  
deterministic functions   2nd   3rd  
DeZign
       database design software  
diagnosing
       locking with profile traces   2nd  
diagrams  
direct recursion   2nd   3rd   4th  
directives
       XML column aliases   2nd  
disabling
       nested triggers  
       transaction logging  
disadvantages
       of indexing  
displaying
       data
               with SELECT   2nd  
DISTINCT
       data retrieval   2nd   3rd  
DISTINCT keyword
       in aggregate functions  
distributed partitioned views  
Distribution agent   2nd  
Distributor  
distriution servers
       configuring   2nd   3rd   4th  
documentation
       Books Online   2nd   3rd  
               Accessing and Changing Relational Data book  
               Administering SQL Server book  
               Analysis Services book  
               Building SQL Server Applications book  
               Contents tab  
               Creating and Maintaining Databases book  
               Creating and Using Data Warehouses book  
               Data Transformation Services book  
               English Query book  
               Getting Started book  
               Glossary  
               How-To book  
               Index tab  
               Installing SQL Server book  
               Meta Data Services book  
               Optimizing Database Performance book  
               Replication book  
               Search tab  
                Transact -SQL reference  
               Troubleshooting book  
               Using SQL Server Tool book  
               What's New? book  
               XML and Internet Support book  
domain integrity   2nd   3rd   4th   5th  
double dash ( ‘)  
drag-and-drop-style questions
       MCP exams   2nd  
DROP FUNCTION  
DROP INDEX statements  
DROP PROCEDURE statement  
DROP TRIGGER statement  
DROP VIEW command  
drop-and-connect questions
       MCP exams  
dropping
       indexes   2nd  
               used by constraints  
       stored procedures   2nd  
       triggers   2nd   3rd  
       user-defined functions  
       views   2nd   3rd  
DTS (Data Transformation Services)   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
Durability  
DYNAMIC   2nd  



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