MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
Index[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] Scale descriptor (columns) Scan for Startup Process option (server properties) schema binding 2nd 3rd 4th SCHEMABINDING option (CREATE VIEW statement) 2nd 3rd schemas scope variables scripts batches 2nd rules 2nd separating definition of SCROLL_LOCKS cursors scrolling cursors second normal form secondary files security 2nd audits 2nd C2 security audits 2nd SQL Profiler security audits 2nd constraints 2nd data access 2nd defaults encryption 2nd 3rd exam prep questions 2nd 3rd Integrated mode Mixed mode object permissions 2nd 3rd 4th 5th 6th permissions roles application roles 2nd creating 2nd definition of 2nd fixed roles viewing list of viewing permissions for SQL Server login/user model 2nd 3rd statement permissions 2nd 3rd 4th 5th stored procedures 2nd troubleshooting broken ownership chains 2nd 3rd SQL Profiler 2nd views 2nd SELECT statement arithmetic operators BETWEEN keyword 2nd bitwise operators column names, specifying 2nd comparison operators 2nd COMPUTE BY clause COMPUTE clause CUBE keyword 2nd DISTINCT clause EXISTS keyword EXPLICIT clause 2nd FOR XML clause 2nd FROM clause GROUP BY clause 2nd HAVING clause INTO clause 2nd LIKE keyword 2nd logical operators 2nd NULL values 2nd OPENXML keyword 2nd 3rd ORDER BY clause 2nd ROLLUP keyword 2nd SET ROWCOUNT clause simple example 2nd 3rd TOP clause 2nd unary operators WHERE clause selecting data [See queries] self-assessment Certified Information Systems Auditor candidate educational background exam readiness 2nd hands-on experience self-referencing entities seraches full-text SERIALIZABLE hint Serializable isolation level Server Network Server Properties dialog box Affinity Mask option Allow Updates option AWE Enabled option C2 Audit Mode option Cost Threshold for Parallelism option Cursor Threshold option Default Full-Text Language option Default Language option Fill Factor option Index Create Memory option Lightweight Pooling option Locks option Max Degree of Parallelism option Max Server Memory option Max Text Repl Size option Max Worker Threads option Media Retention option Min Memory Per Query option Min Server Memory option Nested Triggers option Network Packet Size option Open Objects option Priority Boost option Query Governor Cost Limit option Query Wait option Reconfigure option 2nd Recovery Interval option Remote Access option Remote Login Timeout option Remote Proc Trans option Remote Query Timeout option Scan for Startup Process option Set Working Set Size option Two Digit Year Cutoff option User Connections option User Options option server roles servers [See also SQL Server] linked servers 2nd 3rd 4th remote servers 2nd server configuration settings Affinity Mask Allow Updates AWE Enabled C2 Audit Mode Cost Threshold for Parallelism Cursor Threshold Default Full-Text Language Default Language Fill Factor Index Create Memory Lightweight Pooling Locks Max Degree of Parallelism Max Server Memory Max Text Repl Size Max Worker Threads Media Retention Min Memory Per Query Min Server Memory Nested Triggers Network Packet Size Open Objects Priority Boost Query Governor Cost Limit Query Wait Reconfigure 2nd Recovery Interval Remote Access Remote Login Timeout Remote Proc Trans Remote Query Timeout Scan for Startup Process Set Working Set Size Two Digit Year Cutoff User Connections User Options standby servers 2nd Service Manager 2nd services SQL Server Agent service 2nd 3rd alerts 2nd 3rd 4th 5th 6th jobs 2nd operators 2nd SET IMPLICIT_TRANSACTIONS statement SET ROWCOUNT clause (SELECT statement) Set Working Set Size option (server properties) shared locks sharing query execution plans 2nd single Publisher, single Subscriber replication 2nd SINGLE_USER option (databases) site autonomy 2nd slash-star) smalldatetime data type smallint data type smallmoney data type snapshot replication 2nd 3rd 4th sp_addapprole stored procedure sp_addlinkedserver stored procedure sp_addlogin stored procedure sp_addrole stored procedure sp_addrolemember stored procedure sp_adduser stored procedure sp_changedbowner procedure sp_configure stored procedure sp_dboption procedure sp_dboption stored procedure sp_defaultdb stored procedure sp_depends stored procedure sp_grantdbaccess stored procedure sp_grantlogin stored procedure sp_helpindex stored procedure sp_helpsrvrole stored procedure sp_lock stored procedure sp_monitor stored procedure sp_recompile stored procedure sp_rename stored procedure sp_setapprole stored procedure 2nd sp_settriggerorder stored procedure 2nd sp_spaceused stored procedure sp_srvrolepermission stored procedure sp_who stored procedure sp_xml_preparedocument stored procedure 2nd sp_xml_removedocument stored procedure SPACE() function spaces, trimming specialty data types 2nd SQL 2nd [See also functions] [See also stored procedures] ALTER DATABASE statement 2nd ALTER TRIGGER statement 2nd ALTER VIEW statement BACKUP statement moving data with 2nd BEGIN TRANSACTION statement 2nd 3rd BEGIN...END statement 2nd BREAK statement BULK INSERT statement CASE statement 2nd 3rd CLOSE statement comments 2nd COMMIT TRANSACTION statement COMMIT WORK statement CONTINUE statement CREATE DATABASE statement 2nd 3rd 4th COLLATE clause FILEGROWTH clause MAXSIZE clause 2nd CREATE FUNCTION statement 2nd CREATE INDEX statement 2nd 3rd CREATE PROCEDURE statement 2nd 3rd CREATE TRIGGER statement 2nd CREATE VIEW statement 2nd cursors 2nd 3rd 4th 5th 6th closing creating 2nd deallocating DYNAMIC FAST_FORWARD fetching rows from FORWARD_ONLY GLOBAL KEYSET LOCAL OPTIMISTIC READ_ONLY SCROLL_LOCKS scrolling STATIC TYPE_WARNING updating 2nd database options ANSI_NULL_DEFAULT ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT CONCAT_NULL_YIELDS_NULL NUMERIC_ROUNDABORT QUOTED_IDENTIFIER RECURSIVE_TRIGGERS DBCC DBREINDEX statement DEALLOCATE statement DECLARE CURSOR statement 2nd DELETE statement 2nd 3rd DROP INDEX statement DROP TRIGGER statement DROP VIEW statement EXECUTE statement FETCH NEXT statement GRANT statement 2nd 3rd IF...ELSE statement 2nd INNER JOIN statement 2nd INSERT statement 2nd 3rd loops 2nd 3rd OPEN statement OUTER JOIN statement 2nd 3rd program execution 2nd RESTORE statement moving data with 2nd REVOKE statement 2nd ROLLBACK TRANSACTION statement 2nd scripts batches 2nd definition of SELECT statement arithmetic operators BETWEEN keyword bitwise operators column names, specifying 2nd comparison operators 2nd COMPUTE BY clause COMPUTE clause CUBE keyword 2nd DISTINCT clause EXISTS keyword EXPLICIT clause 2nd FOR XML clause 2nd FROM clause GROUP BY clause 2nd HAVING clause IN keyword INTO clause 2nd LIKE keyword 2nd logical operators 2nd NULL values 2nd OPENXML keyword 2nd 3rd ORDER BY clause 2nd ROLLUP keyword 2nd SET ROWCOUNT clause simple example 2nd 3rd TOP clause 2nd unary operators WHERE clause SET IMPLICIT_TRANSACTIONS statement triggers 2nd 3rd 4th AFTER 2nd altering creating 2nd dropping firing order 2nd 3rd guidelines for use 2nd INSTEAD OF 2nd 3rd 4th renaming TRUNCATE TABLE statement UNION statement 2nd 3rd UPDATE statement variables assigning values to 2nd declaring definition of global variables 2nd scope VIEW statement WITH ENCRYPTION clause SQL Profiler 2nd monitoring activity with 2nd 3rd security audits 2nd templates traces defining 2nd diagnosing locking with 2nd 3rd 4th 5th 6th playback and diagnosis 2nd SQL Server 2nd [See also databases] [See also security] alerts definition of Analysis Services automation 2nd 3rd 4th alerts 2nd 3rd 4th 5th 6th jobs 2nd operators 2nd Back Office integration 2nd BCP (Bulk Copy Program) Books Online 2nd cascading referential integrity Client Network collations data types 2nd binary data types 2nd character data types 2nd metadata 2nd numeric data types 2nd object definitions 2nd specialty data types 2nd user data 2nd user-defined data types 2nd database design 2nd distributed partitioned views English Query hardware requirements 2nd 3rd 4th 5th 6th 7th indexed views INSTEAD OF and AFTER triggers jobs definition of linked servers locks by object locks by process ID logins logs multiple instance connections operators definition of OSQL (ODBC Structured Query Language) overview of 2nd partitioned views process information definition of Profiler program execution 2nd Query Analyzer 2nd 3rd remote servers Server Network server roles Service Manager 2nd SQL Server Agent service 2nd 3rd alerts 2nd 3rd 4th 5th 6th jobs 2nd operators 2nd system objects 2nd T-SQL functions tools 2nd 3rd 4th user objects 2nd XML support SQL Server Agent service 2nd 3rd alerts 2nd event alerts 2nd performance counter alerts 2nd jobs 2nd operators 2nd SQL Server databases [See databases] sql_variant data type SQLSERVERAGENT source (application log) SQRT() function SQUARE() function standby servers 2nd state database options MULTI_USER OFFLINE READ_ONLY READ_WRITE RESTRICTED_USER SINGLE_USER WITH termination (termination in italic) 2nd statement permissions 2nd 3rd 4th 5th statements ALTER DATABASE 2nd ALTER TRIGGER 2nd ALTER VIEW BACKUP moving data with 2nd BEGIN TRANSACTION 2nd 3rd BEGIN...END 2nd BREAK BULK INSERT CASE 2nd 3rd CLOSE COMMIT TRANSACTION COMMIT WORK CONTINUE CREATE DATABASE 2nd 3rd 4th COLLATE clause FILEGROWTH clause MAXSIZE clause 2nd CREATE FUNCTION 2nd CREATE INDEX 2nd 3rd CREATE PROCEDURE 2nd 3rd CREATE TRIGGER 2nd CREATE VIEW 2nd DBCC DBREINDEX statement DEALLOCATE DECLARE CURSOR 2nd DELETE 2nd 3rd DROP INDEX statement DROP TRIGGER DROP VIEW EXECUTE FETCH NEXT GRANT 2nd 3rd IF...ELSE 2nd INNER JOIN 2nd INSERT 2nd 3rd loops 2nd 3rd OPEN OUTER JOIN 2nd 3rd RESTORE moving data with 2nd REVOKE 2nd ROLLBACK TRANSACTION 2nd SELECT arithmetic operators BETWEEN keyword bitwise operators column names, specifying 2nd comparison operators 2nd COMPUTE BY clause COMPUTE clause CUBE keyword 2nd DISTINCT clause EXISTS keyword EXPLICIT clause 2nd FOR XML clause 2nd FROM clause GROUP BY clause 2nd HAVING clause IN keyword INTO clause 2nd LIKE keyword 2nd logical operators 2nd NULL values 2nd OPENXML keyword 2nd 3rd ORDER BY clause 2nd ROLLUP keyword 2nd SET ROWCOUNT clause simple example 2nd 3rd TOP clause 2nd unary operators WHERE clause SET IMPLICIT_TRANSACTIONS TRUNCATE TABLE UNION 2nd 3rd UPDATE VIEW WITH ENCRYPTION clause STATIC cursors statistical functions 2nd 3rd STATS_DATE() function STDDEV() function STDDEVP() function stored procedures 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th creating 2nd 3rd definition of output 2nd recompilation 2nd security 2nd sp_addapprole sp_addlinkedserver sp_addlogin sp_addrole sp_addrolemember sp_adduser sp_changedbowner sp_configure sp_dboption 2nd sp_defaultdb sp_depends sp_grantdbaccess sp_grantlogin sp_helpindex sp_helpsrvrole sp_lock sp_monitor sp_recompile sp_rename sp_setapprole 2nd sp_settriggerorder 2nd sp_spaceused sp_srvrolepermission sp_who sp_xml_preparedocument 2nd sp_xml_removedocument web applications and 2nd strings functions 2nd 3rd spaces, trimming STUFF() function Subscribers central Publisher, multiple Subscribers 2nd multiple Publishers, multiple Subscribers 2nd multiple Publishers, single Subscriber single Publisher, single Subscriber 2nd SUBSTRING() function 2nd 3rd SUM() function surrogate keys SUSER_SID() function SUSER_SNAME() function syscolumns tables syscomments tables sysdatabases tables sysindexes tables syslogins tables sysmessages tables sysobjects tables sysprocesses tables sysremotelogins tables sysservers tables system design 2nd automation 2nd 3rd 4th alerts 2nd 3rd 4th 5th 6th jobs 2nd operators 2nd distributed data 2nd linked servers 2nd 3rd 4th OLE-DB 2nd OPENQUERY function OPENROWSET function 2nd 3rd remote servers 2nd exam prep questions 2nd 3rd 4th 5th Internet application architecture 2nd one-tier systems 2nd replication 2nd merge replication 2nd snapshot replication 2nd transactional replication SQL Server Back Office integration 2nd third-party database interactions 2nd three- or more tier systems 2nd two-tier systems 2nd very large database applications 2nd system objects 2nd system-level functions 2nd 3rd systypes tables sysusers tables |