Index S


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

SAVE TRANSACTION  
savepoints  
scalar functions   2nd  
       creating   2nd   3rd   4th  
scheduling
       statistics updates  
schema  
       schema binding   2nd  
schema binding   2nd   3rd  
SCHEMABINDINg  
SCHEMABINDING  
       indexed views  
scopes
       of variables   2nd  
scoping
       stored procedures   2nd   3rd   4th  
scripts   2nd   3rd  
       writing   2nd  
SCROLL LOCKS   2nd  
scrolling
       through cursors   2nd  
searches
       CONTAINS searches   2nd   3rd   4th   5th   6th  
       CONTAINSTABLE searches   2nd  
       FREETEXT searches   2nd  
       FREETEXTTABLE searches   2nd  
       full-text searches
               LIKE  
second normal form (2NF)   2nd   3rd  
securing
       objects  
               C2 security  
               security audits   2nd  
               statement and object permissions   2nd   3rd  
security  
       application roles   2nd  
       object permissions   2nd  
       SQL Server Login/ User Model   2nd   3rd  
       statement permissions   2nd  
       triggers
               controlling modifications   2nd  
               enforcing referential and data integrity   2nd   3rd   4th   5th  
       user roles  
               defining  
               fixed roles  
security audits   2nd  
SELECT   2nd   3rd  
       inserting data  
SELECT CURSOR STATUS  
SELECT INTO   2nd  
SELECT INTO/BULKCOPY option  
SELECT statement  
       data
               displaying   2nd  
       data retrieval   2nd   3rd   4th   5th   6th   7th  
               arguments  
               changing column headers   2nd   3rd  
               DISTINCT   2nd   3rd  
               string concatenation   2nd  
SELECT statements
       views   2nd   3rd   4th   5th   6th   7th  
               limitations in view definitions  
selecting
        columns
               in views   2nd   3rd   4th   5th  
       rows
               based on null values   2nd  
               in views   2nd   3rd   4th  
       subscribers  
       TOP data  
selectivity
       indexing   2nd  
Serializable  
Server Network utility  
SERVERPROPERTY  
servers
       configuration settings  
               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  
       distribution servers
               configuring   2nd   3rd   4th  
       federation of servers  
       linked servers  
       managing
               Enterprise Manager utility   2nd  
       multiple  
               balancing the load  
               partitioning   2nd  
               replication   2nd  
       registering   2nd  
Service Manager utility   2nd   3rd  
services
       managing
               Service Manager utility  
session settings
       switching  
SESSION USER  
SESSIONPROPERTY  
SET options
       Query Analyzer   2nd   3rd  
SET STATISTICS
       Query Analyzer  
SET TRANSACTION ISOLATION LEVEL commands  
shared locks  
sharing
       execution plans
               Query Analyzer   2nd  
SHOWCONTIG  
SHRINKDATABASE  
SHRINKFILE  
shrinking
       files  
side effects
       user-defined functions   2nd  
SIMPLE database configuration option  
SIMPLE mode (database recovery)  
Simple Network Management Protocol.   [See SNMP]
Simple recovery model  
simulation questions
       MCP exams   2nd   3rd   4th   5th  
single quotation marks  
SINGLE_USER database configuration option  
site autonomy
       replication  
slash-star (/*) comments  
smalldatetime data type  
smallmoney data type  
SmartDraw
       database design software  
Snapshot agent   2nd   3rd  
snapshot replication   2nd   3rd  
       changing snapshot location   2nd  
       how it works   2nd  
       network considerations  
SNMP  
SNMP (Simple Network Management Protocol)   2nd  
software
       for logical database design  
software requirements
       PrepLogic practice tests  
sp adduser command  
sp configure  
       optimizing SQL Server configurations  
sp cursor list  
sp dboption
       optimizing SQL Server configurations  
sp depends  
sp describe cursor  
sp describe cursor columns  
sp describe cursor tables  
sp grantdbaccess  
sp grantlogin command  
sp help
       optimizing SQL Server configurations  
sp helpindex   2nd  
sp helptext  
sp helptext command  
sp lock  
       optimizing SQL Server configurations  
sp monitor  
       optimizing SQL Server configurations  
sp recompile  
sp rename   2nd   3rd  
sp settriggerorder  
sp spaceused  
       optimizing SQL Server configurations  
sp trace create  
sp trace generateevent  
sp trace setevent  
sp trace setfilter  
sp trace setstatus  
sp who   2nd   3rd  
       optimizing SQL Server configurations  
sp_configure stored procedure  
sp_dboption stored procedure  
sp_xml_preparedocument stored procedure   2nd  
sp_xml_removedocument stored procedure  
space requirements   2nd  
       file growth strategies   2nd  
       shrinking files  
specialty data types   2nd   3rd  
speed
       of BCP  
SQL (Structured Query Language)   2nd  
       Transact-SQL  
SQL Profiler   2nd  
       advantages of  
       monitoring activities   2nd   3rd  
       stored procedures
               optimizing SQL Server configurations   2nd  
       templates  
       traces  
               creating   2nd   3rd  
               defining   2nd   3rd   4th   5th  
               to diagnose locking   2nd  
SQL Query Analyzer.   [See Query Analyzer]
SQL Server
       hardware requirements for installing   2nd  
       results   2nd  
SQL Server 2000
       as a resource  
       features   2nd   3rd  
               new   2nd   3rd   4th   5th  
       limitations  
               back office integration  
       requirements   2nd  
               hardware  
       software  
       statistics  
       versions  
               Developer Edition  
               Enterprise Edition  
               Enterprise Evaluation Edition  
               Personal Edition  
               Standard Edition  
       versions\:Windows CE Edition  
SQL Server 2000 Enterprise Edition  
SQL Server agent  
SQL Server Books online  
SQL Server configurations
       optimizing  
               Current Activity window.   [See Current Activity window]
               stored procedures.   [See stored procedures]
SQL Server data types   2nd   3rd  
SQL Server debugging information
       viewing with Enterprise Manager  
SQL Server Login/User Model   2nd   3rd  
SQL Server Maintenance wizard  
SQL Server Profiler  
SQL Server Query Optimizer   2nd   3rd  
       proactive optimization  
               alerts  
               Database Maintenance Plan Wizard  
               jobs  
               operators   2nd   3rd  
               performance counter alerts   2nd  
       Query Analyzer   2nd   3rd  
               caching and sharing execution plans   2nd  
               execution plans   2nd   3rd  
               hints   2nd   3rd  
               reading execution plans   2nd   3rd  
               SET options   2nd   3rd  
               SET STATISTICS  
sql variant data type  
SQL VARIANT PROPERTY  
SQL-92  
sql_variant data type  
standard order of operations  
standby servers  
state parameter  
statement blocks
       BEGIN and END   2nd   3rd  
statement permissions   2nd   3rd   4th   5th   6th  
statements
       ALTER FUNCTION  
       ALTER TABLE  
       ALTER TRIGGER  
       ALTER VIEW   2nd  
       conditional statements
               IF ‰THEN ‰ELSE   2nd   3rd   4th   5th  
       CREATE INDEX   2nd   3rd   4th  
               creating indexed views   2nd   3rd  
       CREATE PROCEDURE   2nd   3rd   4th  
       CREATE TABLE  
       CREATE TRIGGER   2nd   3rd   4th  
       CREATE VIEW   2nd  
       DBCC DBREINDEX   2nd  
       DBCC IDNEXDEFRAG  
       DECLARE CURSOR  
STATEMENTS
       DECLARE CURSOR  
statements
       DELETE   2nd  
       DROP INDEX  
       DROP PROCEDURE  
       DROP TRIGGER  
       ELSE   2nd  
        EXEC
               stored procedures   2nd   3rd   4th  
       GRANT  
       IF  
       INSERT   2nd  
       INSERT EXECUTE   2nd  
       INSERT INTO  
       INSERT INTO SELECT   2nd  
       OPEN  
       PRINT  
       RAISERROR   2nd  
       RETURN   2nd   3rd  
       SELECT
               data retrieval.   [See data retrieval]
               views  
       SELECT INTO   2nd  
       TRUNCATE TABLE   2nd  
       UPDATE   2nd  
       UPDATE STATISTICS   2nd  
       WHILE  
       WITH RECOMPILE  
STATIC   2nd  
statistical aggregate functions   2nd   3rd  
statistics  
       and indexing   2nd   3rd  
       indexing
               querying   2nd  
               querying and updating  
               scheduling updates  
STATS DATE   2nd   3rd  
STATS DATE command  
status DBCC operations   2nd  
STDEV() function   2nd  
STDEVP() function   2nd  
stored procedures   2nd   3rd   4th   5th   6th   7th   8th  
       advantages of  
       altering  
       and temporary tables   2nd   3rd   4th  
       and web applications  
       calling   2nd   3rd   4th   5th   6th  
       creating   2nd   3rd   4th   5th   6th   7th  
               with Enterprise Manager   2nd   3rd   4th  
       cursors   2nd  
       data modification
               constraining   2nd  
       dropping   2nd  
       enforcing procedural business logic   2nd   3rd   4th   5th  
       error handling   2nd   3rd   4th   5th   6th  
       EXEC statement   2nd   3rd   4th  
       extended  
       filtering data   2nd   3rd  
       full-text stored procedures   2nd  
       groups   2nd  
       nested stored procedures   2nd  
       passing back return values   2nd  
       recompiling  
       scoping   2nd   3rd   4th  
       sp configure  
               optimizing SQL Server configurations  
       sp dboption
               optimizing SQL Server configurations  
       sp depends  
       sp help
               optimizing SQL Server configurations  
       sp helpindex   2nd  
       sp helptext  
       sp lock  
               optimizing SQL Server configurations  
       sp monitor  
               optimizing SQL Server configurations  
       sp recompile  
       sp rename   2nd   3rd  
       sp settriggerorder  
       sp spaceused  
               optimizing SQL Server configurations  
       sp who   2nd   3rd  
               optimizing SQL Server configurations  
       sp_configure  
       sp_dboption  
       SQL Profiler
               optimizing SQL Server configurations   2nd  
       SQL SQL Server configurations  
               sp configure  
               sp dboption  
               sp help  
               sp lock  
               sp monitor  
               sp spaceused  
               sp who  
               SQL Profiler   2nd  
               xp sqlmaint  
       system stored procedures   2nd  
       temporary  
       text   2nd  
       versus functions  
       xp sqlmaint
               optimizing SQL Server configurations  
stored procedures.   [See also commands]
string concatenation
       data retrieval   2nd  
Structure Query Language (SQL)   2nd  
       Transact-SQL  
study strategies  
       active study strategies   2nd  
       common-sense study strategies  
       macro study strategies   2nd  
       micro study strategies   2nd  
       pre-testing   2nd  
study strategies.   [See also exam prep tips]
study tips  
style
       writing SQL queries  
Subscriber  
subscribers
       selecting  
Subscribers
       updating  
               immediate updating   2nd   3rd  
               queued updating   2nd  
               remote agent activation   2nd  
subscriptions
       anonymous subscriptions  
       Publisher/Subscriber metaphor  
       pulling   2nd   3rd   4th  
SUBSTRING   2nd  
substring function  
SUM() function  
summarizing
       data   2nd  
               character functions.   [See character functions]
               date functions.   [See date functions]
               mathematical functions   2nd   3rd  
               system functions  
summarizing data   2nd  
       CUBE and ROLLUP operators
               versus COMPUTE and COMPUTE BY operators   2nd  
       CUBE operator   2nd  
       GROUPING keyword   2nd  
       ROLLUP operator   2nd   3rd  
       target audience for reports  
summarizing data.   [See also grouping data]
surrogate keys  
switches.   [See parameters]
switching
       session settings  
sysindexes system  
system error messages   2nd  
system functions   2nd   3rd   4th   5th   6th  
       information schema   2nd  
       system stored procedures   2nd  
system maintenance  
System Monitor   2nd   3rd   4th   5th   6th  
       optimizing OS configurations   2nd   3rd   4th  
       Windows 2000 System Monitor  
system statistical functions   2nd   3rd  
system stored procedures   2nd  
system tables  
SYSTEM USER  



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