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]

sample databases
scale
Scan For Startup Procs configuration option
scheduler
     binding to CPUs
     dedicated administrator connection (DAC)
     dynamic affinity
     Non-Uniform Memory Access (NUMA)
     observing internals
     overview
     SQL Server schedulers
     SQL Server tasks
     SQL Server workers
     threads vs. fibers
scheduler_id column 2nd
scheduling configuration options
schema modification locks
schema stability locks
schemas
     compared to databases
     default
     separation of principals and schemas
secondary data files
securable vs. object
security
    database [See database security]
     pre-installation decisions
Serializable isolation
SERIALIZABLE keyword
Server Trigger Recursion configuration option
Service Broker database options
service name
services
     disabling nonessential
     managing
session ID (SPID)
session_id column
SET options
Set Working Set Size configuration option 2nd
Shared Global Allocation Map (SGAM) pages
shared locks 2nd
Shared Memory protocol
Show Advanced Options configuration option
shrinking databases 2nd
SI (SNAPSHOT isolation) 2nd
SIMPLE recovery model
single-byte characters (char and varchar)
single_pages_in_use_kb column
single_pages_kb column 2nd
SINGLE_USER database option
size column
sizing buffer pools
     memory configurations
     multiple instances on a single computer
     Non-Uniform Memory Access (NUMA)
     observing memory internals
     overview
     read-ahead memory mechanism
     Target Memory value
sizing memory
smalldatetime values
SMO and DMO XPs configuration option
snapshot isolation
     behaviors allowed
     Data Definition Language (DDL)
     database options
     overview 2nd
     RCSI vs. SI 2nd
     READ COMMITTED SNAPSHOT isolation (RCSI)
     scope
     SNAPSHOT isolation (SI)
     snapshot transaction metadata
     sys.databases catalog view
     types of
     update conflicts
     version store
snapshots, database
     creating
     managing
     overview
     space used by
software requirements
sort orders
     binary sorting
     overview
     performance considerations
     semantics
     specifying collation
sorting, index
space allocation in databases
space monitoring in tempdb database
space requirements in indexes
special indexes
     COLUMNPROPERTY function
     computed columns
     deterministic vs. nondeterministic functions
     implementation
     overview
     persisted columns
     prerequisites
     schema binding
     SET options
     views 2nd
SPID (session ID)
spinlocks
splitting pages in indexes
SQL database options 2nd
SQL Enterprise Manager
SQL Mail XPs configuration option
SQL manager
SQL Native Client
SQL operating system (OS)
     binding schedulers to CPUs
     dedicated administrator connection (DAC)
     dynamic affinity
     NUMA and schedulers
     NUMA architecture
     observing scheduler internals
     overview
     scheduler overview
     SQL Server schedulers
     SQL Server tasks
     SQL Server workers
     threads vs. fibers
SQL Query Analyzer 2nd
SQL Server 2005 Upgrade Advisor
SQL Server authentication
SQL Server Books Online 2nd
SQL Server Configuration Manager [See also configurations]
     configuring network protocols
     default network protocols
     managing services
     overview
SQL Server Database Services [See also database engine]
     clustering
     full-text search
     overview
     replication
SQL Server Enterprise Manager
SQL Server Management Studio 2nd 3rd
SQL Server schedulers
SQL Server storage engine
     access methods overview
     controlling utilities
     locking operations
     overview
     page allocation operations
     row and index operations
     transaction services
     versioning operations
SQL Server tasks
SQL Server workers
SQL-92 reserved keywords
sql_variant data 2nd
SQLOS layer
     binding schedulers to CPUs
     dedicated administrator connection (DAC)
     dynamic affinity
     NUMA and schedulers
     NUMA architecture
     observing scheduler internals
     overview
     scheduler overview
     SQL Server schedulers
     SQL Server tasks
     SQL Server workers
     threads vs. fibers
stack_bytes_used column
Standard Edition
standby files
started_by_sqlservr column
state column
state database options
     EMERGENCY
     emergency mode repair
     MULTI_USER
     NO_WAIT
     OFFLINE
     ONLINE
     overview 2nd
     READ_ONLY
     RESTRICTED_USER
     ROLLBACK AFTER integer [SECONDS]
     ROLLBACK IMMEDIATE
     SINGLE_USER
     termination options
state_desc column
statistic updates during upgrades
storage engine
     access methods overview
     controlling utilities
     locking operations
     overview
     page allocation operations
     row and index operations
     transaction services
     versioning operations
storage of data
     LOB data
     metadata
     sql_variant data
     varchar(MAX) data
structure of indexes
     clustered index node rows
     clustered index rows with uniqueifier
     DBCC IND command
     index row formats
     nonclustered index leaf rows
     nonclustered index node rows
     overview
     sys.system_internals_allocation_units view
Surface Area Configuration Tool 2nd
SWITCH option to ALTER TABLE command
sys.allocation_units view
sys.database_files view
sys.databases catalog view 2nd
sys.dm_db_file_space_usage view
sys.dm_db_index_physical_stats function
sys.dm_db_session_space_usage view
sys.dm_db_task_space_usage view
sys.dm_os_memory_cache_clock_hands view
sys.dm_os_memory_cache_counters view
sys.dm_os_memory_cache_hash_tables view
sys.dm_os_memory_clerks view
sys.dm_os_schedulers view
sys.dm_os_tasks view
sys.dm_os_threads view
sys.dm_os_waiting_tasks view
sys.dm_os_workers view
sys.dm_tran_locks view 2nd
sys.indexes view
sys.partitions view
sys.system_internals_allocation_units view
syslockinfo table
system base tables
system catalogs
system configurations [See also configurations]
     compatibility with earlier SQL Server versions
     default trace
     network protocols
     nonessential services
     overview
     resource allocation
    settings [See configuration settings]
     system paging file location
     task management
     trace flags
system databases 2nd
system functions
system objects
     catalog views
     compatibility views
     information schema views
     overview
     system functions
     system stored procedures
system paging file location
system stored procedures