S

Index

[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

sampling stored data
scalar-valued functions
Scans event class (SQL Profiler)
SCC (System Configuration Checker), SQL Server installations
SCHEMABINDING clause
secondary databases
secondary servers, read-only
secondary XML indexes
security
     credentials
     database roles
     dialogues
     linked server configurations (SQL Server)
     logins 2nd
     permissions
     server roles
Security Audit event class (SQL Profiler)
SELECT INTO option, bcp command
SELECT INTO statements, system views
select into/bulkcopy database option
SELECT statements
     GROUP BY clause
     HAVING clause
     ORDER BY clause
     TABLESAMPLE clause
     TOP clause
     WHERE clause
self-assessment
     Certified Information Systems Auditor candidate
     educational background
     exam readiness
     hands-on experience
SEND statements, dialogues
Server event class (SQL Profiler)
servers
     federations
     maintenance, DBCC
     roles
Service Broker
     components of
     contracts, providing details
     dialogues
     message type, defining
     queues, creating
     services, assembling components into
Sessions event class (SQL Profiler)
SET command, indexed views
SET RECOVERY option
shared locks
simple recovery models
single publisher and a remote distributor strategies (replication)
site autonomy, replication
SKIP option, BACKUP statements
smalldatetime data type
smallint data type
smallmoney data type
snapshots
     databases 2nd
     replication 2nd
SNMP (Simple Network Management Protocol), SQL Server performance
software requirements for SQL Server installation
sp dboption stored procedure, setting recovery models
sp lock stored procedures
sp_dboption stored procedure [See ALTER DATABASE statements.]
SQL Profiler
     data captures
     data storage
     event class categories list
     templates
     traces
SQL Server
     database maintenance
         automating
         BACKUP VERIFYONLY option
         CONTINUE_AFTER_ERROR option
         database backups
         database snapshots 2nd
         fast recovery
         job scheduling
         mirrored backup sets
         partial database restores
         RESTORE VERIFYONLY option
     high availability, implementing
     impersonations
     installing
         DBMS
         hardware requirements
         installation process
         Migration Assistant
         operating system requirements
         postinstallation procedures
         preparations for
         RAID
         SCC
         support software requirements
     linked server configurations
     login security
     metadata, viewing
     optimizing, readings/resources
    performance
         Activity Monitor
         baselines
         DBCC
         DTA
         dynamic management functions and views
         Log File Viewer
         readings/resources
         SNMP
         SQL Profiler
         System Monitor
         trace flags
     readings/resources
     troubleshooting, readings/resources
     user authentication
SQL Server Agent 2nd
SQL Server logs, Log File Viewer
SQL Server Profiler, trapping lock events
SQL Server Query Optimizer
sql variant data type
SQLServer:Locks object
sqlsrvr.exe command
SSAS (SQL Server Analysis Services)
SSIS (SQL Server Integration Services)
     importing data with
     uses of
standard view, importing/exporting data
STANDBY option, BACKUP statements
STARTED state (endpoints)
statistics 2nd
Status column (Activity Monitor)
STOP ON ERROR option, BACKUP statements
STOPPED state (endpoints)
stored procedures 2nd
     CLR
    sp_dboption [See ALTER DATABASE statements.]
     system views
Stored Procedures event class (SQL Profiler)
storing data, partitioned tables
string concatenation
subscribers, role in replication
     central publisher and multiple subscribers strategies
     multiple publishers and multiple subscribers strategies
     multiple publishers and single subscriber strategies
subscriptions (push/pull)
support software requirements, SQL Server installations
symmetric design (partitioning tables)
synchronous processing
synonyms
sys.databases catalog view
sys.dm exec requests dynamic management view
sys.dm exec sessions dynamic management view
sys.dm tran locks dynamic management view
syscomments system tables
sysobjects system tables
system databases, backups as
System Monitor
     counters list
     prefixes list
System Process column (Activity Monitor)
system tables
system views
     ALTER INDEX REBUILD statements
     ALTER TABLE NOCHECK CONSTRAINT statements
     CLR
     common views list
     DISABLE INDEX statements
     DISABLE TRIGGER statements
     dynamic management views
     ENABLE TRIGGER statements
     FROM clause
     INSERT SELECT statements
     INSERT statements
    inserting
         complete recordsets
         data, disabling functionality
         individual records
     SELECT INTO statements
     stored procedures 2nd
     temporary tables
     UDT
     VALUES keyword
system-stored procedures