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