S

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