Index S


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

sa account
       password
               changing  
SARG
       selectivity, index selection and   2nd   3rd   4th  
SAVE TRAN command  
savepoints
       transaction triggers   2nd   3rd   4th  
savepoints, transactions   2nd   3rd  
saving
       traces, Profiler   2nd   3rd   4th   5th  
scalability
       enterprise computing   2nd   3rd  
scalar functions   2nd   3rd   4th   5th  
scalar values
        user -defined functions  
scan for startup procs, configuration  
Scan physical operator, Query Analyzer   2nd  
scans
       indexes  
scatter-gather I/O   2nd  
scenarios, replication
       central publisher   2nd   3rd   4th  
       central publisher with remote distributor   2nd   3rd  
       central subscriber  
       multiple subscribers   2nd  
       publishing subscriber scenario   2nd  
scheduling  
       Jobs  
schema locks   2nd  
SCHEMABINDING option
       function creation  
schemas
       views
               system stored procedures   2nd  
scripting
       alerts, Agent   2nd  
       Jobs, Agent   2nd  
scripting objects   2nd   3rd  
scripting replication   2nd   3rd   4th  
scripts
       table creation
               Table Designer   2nd  
       templates
               Query Analyzer   2nd   3rd   4th  
scrollable cursors   2nd   3rd  
search arguments (SARG)
       query optimization and   2nd   3rd   4th   5th   6th   7th   8th   9th  
Search Server   2nd   3rd   4th   5th   6th   7th   8th   9th  
       commands   2nd   3rd   4th   5th   6th   7th  
       noise words  
searches   [See also full-text searches]
       range searches
               key locking and   2nd   3rd   4th   5th  
       text
               enhancements   2nd  
       text searches
               limiting hits  
secondary data files   2nd  
secondary files  
security   [See also permissions]
       account security  
       AS  
       authentication methods   2nd   3rd   4th   5th  
        columns , views   2nd   3rd  
       connections
               Internet   2nd  
       database engine and  
       dbo account  
       encryption   2nd  
       Enterprise Manager and  
       linked servers   2nd   3rd   4th   5th  
       login  
       logins   2nd   3rd  
               Enterprise   2nd  
       MTS
               configuration   2nd   3rd   4th   5th   6th   7th  
       overview   2nd  
       permissions   2nd  
       roles   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
               Enterprise Manager   2nd  
       rows, views   2nd   3rd   4th  
       servers
               configuration   2nd  
       SNMP  
       trusted connections  
       user management   2nd   3rd  
       users   2nd   3rd  
       views and   2nd  
       Windows XP and  
security functions   2nd  
Security Roles Wizard, AS  
SELECT DISTINCT statement  
SELECT INTO   2nd  
SELECT permission  
SELECT statement   2nd   3rd   4th  
       FROM clause
               table-valued functions  
       linked servers and  
       ORDER BY clause   2nd  
               TOP keyword  
       TOP keyword   2nd   3rd   4th  
       UNION keyword   2nd  
       views  
       WHERE clause   2nd   3rd  
semijoin reduction  
Sequence operator, Query Analyzer  
sequence tree, query compilation and  
Serializable Read mode, isolation levels   2nd   3rd  
serialization
       key range locking and   2nd   3rd   4th   5th   6th  
Server
       mail  
Server Groups (EM)   2nd  
Server Logs, Enterprise Manager   2nd  
Server Manager  
Server Messages, Enterprise Manager   2nd  
Server Network Utility  
server roles  
server side traces, Profiler   2nd   3rd  
server threads   2nd   3rd   4th   5th  
Server Trace, Query Analyzer   2nd  
server-side Net-Libraries   2nd  
Server/Per-Seat Client Access License (CAL)  
servers  
       configuration
               Enterprise Manager   2nd   3rd   4th  
       connecting to
               Enterprise Manager and   2nd  
       disconnecting from
               Enterprise Manager and   2nd  
       distribution
               configuration  
       hardware
               connection troubleshooting and  
       linked
               Enterprise Manager  
               remote servers  
               security   2nd   3rd   4th   5th  
       linked servers   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
               distributed queries   2nd  
               remote datasources   2nd   3rd   4th  
               T-SQL and   2nd   3rd   4th   5th  
       linked.   [See linked servers]
       master  
       multiple, job management   2nd   3rd  
        names   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th  
       overview   2nd   3rd   4th   5th   6th   7th   8th  
       registering
               Enterprise Manager   2nd  
       remote
               Enterprise Manager  
       remote.   [See remote servers]
       replication
               distribution server  
               publication server  
               subscription server   2nd  
       software
               connection troubleshooting and  
       standby servers, backups   2nd   3rd  
       starting/stopping
               Enterprise Manager   2nd  
       target  
       target servers  
Service Manager
       overview   2nd  
Service Pack 5
       installation and  
SET command   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       CONTEXT INFO setting   2nd   3rd   4th  
       session options   2nd   3rd   4th   5th   6th   7th  
SET SHOWPLAN ALL option   2nd   3rd   4th   5th  
SET SHOWPLAN TEXT option   2nd   3rd   4th   5th  
SET STATISTICS PROFILE option, Query Analyzer   2nd  
SET TRANSACTION ISOLATION LEVEL statement  
set working set size, configuration   2nd  
setup
       linked servers
               Enterprise Manager   2nd   3rd  
       remote servers   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       replication   2nd  
                publications , creating   2nd   3rd   4th   5th  
               publishing, enabling   2nd   3rd   4th  
               subscriptions, creating   2nd   3rd   4th   5th   6th  
severity levels   2nd   3rd   4th  
SGAM (Secondary Global Allocation Map)  
SGAM (Shared Global Allocation Map)  
SGLAgentMail
       notification
               alerts   2nd   3rd   4th  
SGML (Standard Generalized Markup Language)  
shared locks   2nd   3rd  
shared locks, transactions   2nd   3rd   4th   5th  
Shared Property Manager, MTS and  
shared-query plans, stored procedures   2nd   3rd   4th   5th   6th  
shortcuts
       Query Analyzer   2nd  
SHOWCONTIG command (DBCC), performance monitoring  
SHOWPLAN options   2nd   3rd   4th   5th  
shrinking
       databases   2nd   3rd   4th   5th  
shrinking databases  
       Enterprising Manager  
shrinking log files   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
simple recovery   2nd  
SIX (shared intent exclusive) locks   2nd   3rd  
size
       clustered indexes
               estimating   2nd   3rd   4th   5th  
       columns  
       nonclustered indexes   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               estimated versus actual   2nd   3rd   4th   5th  
       rows  
       tables
               limitations   2nd  
Snapshot Agent  
snapshot agent
       .SCH (schema) files  
Snapshot Agent
       merge replication  
       transactional replication  
snapshot agent (replication)   2nd   3rd   4th   5th  
       processing   2nd   3rd   4th  
       synchronization and  
snapshot replication   2nd   3rd   4th  
snapshot replication with updating subscribers  
SNMP (Simple Network Management Protocol)   2nd  
snmputil  
sockets
       TCP/IP Sockets  
software
        clients
               connection troubleshooting and  
       servers
               connection troubleshooting and  
software requirements  
       file system   2nd  
       operating system  
       upgrades   2nd  
Sort operator, Query Analyzer  
source code
       stored procedures  
               Query Analyzer   2nd   3rd   4th  
source code control software   2nd   3rd  
sp_addextendedproc system stored procedure  
sp_addlinkedserver   2nd   3rd   4th   5th   6th   7th   8th   9th  
sp_addlinkedsrvlogin   2nd   3rd   4th   5th   6th   7th  
sp_addserver   2nd  
sp_addumpdevice stored procedure  
sp_configure stored procedure  
SP_CONFIGURE system-stored procedure  
sp_dboption system-stored procedure  
sp_droplinkedsrvlogin   2nd  
sp_dropserver   2nd  
sp_executesql   2nd   3rd   4th   5th   6th   7th  
       OUTPUT parameters and   2nd   3rd   4th  
sp_helpextendedproc stored procedure  
sp_helplinkedsrvlogin   2nd   3rd  
sp_helptext procedure  
sp_linkedserver   2nd  
sp_lock stored procedure   2nd   3rd  
sp_password stored procedure  
sp_processmail stored procedure   2nd   3rd   4th  
sp_publication_validation stored procedure   2nd  
sp_recompile system stored procedure   2nd  
sp_replcounters stored procedure  
sp_serveroption   2nd   3rd   4th   5th   6th   7th  
sp_settriggerorder stored procedure  
sp_tableoption stored procedure  
space allocation
       IAM   2nd   3rd   4th   5th   6th   7th  
       PFS   2nd  
space allocation, database pages   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
       extents   2nd   3rd  
       GAM pages   2nd   3rd   4th  
special datatypes  
specifications
       OLE DB  
Split physical operator, Query Analyzer  
SPM (Shared Property Manager)  
SPP (Sequenced Packet Protocol), Banyan Vines   2nd  
SQL
       .NET Framework and  
       clauses
               English Query and   2nd  
SQL (Structured Query Language)  
SQL 2000
       retail pricing  
SQL collation  
SQL Mail, Enterprise Manager  
SQL Mail.   [See Mail]
SQL options  
SQL Profiler, Enterprise Manager  
SQL Server
       connecting to
               installation  
       pausing  
       platform matrix  
       starting  
       stopping  
       Windows 98 and  
       Windows Me and  
SQL Server 2000
       Desktop Engine
               Windows 2000 Professional and   2nd  
               Windows 98 and  
               Windows Me and  
       enhancement
               64GB memory support  
       enhancements
               64-bit version   2nd  
               analysis services   2nd  
               backup enhancements   2nd  
               clustering enhancements  
               collation enhancements   2nd  
               DBCC enhancements  
               full-text search enhancements   2nd  
               index enhancements   2nd  
               restore enhancements   2nd  
       new features   2nd  
               AFTER triggers  
               cascading RI constraints   2nd  
               datatypes, new   2nd  
               distributed partitioned views  
               indexed views   2nd  
               INSTEAD OF triggers  
               JDBC driver   2nd  
               log shipping   2nd  
               multiple instances   2nd  
               Notification Services  
               text in row data   2nd  
               user-defined functions   2nd  
               XML support   2nd  
       Personal
               Windows 2000 Professional and   2nd  
       Standard Edition
               Windows 98 and  
               Windows Me and  
SQL Server 7.0
       new features   2nd   3rd   4th  
SQL Server Agent
       snapshot agent  
SQL statements
       monitoring replication and   2nd   3rd   4th   5th  
sql variant datatype   2nd  
sql_variant datatype
       hierarchy   2nd  
sql_variant datatype, T-SQL   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
SQLAgentMail  
       configuration   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       mail notification   2nd   3rd   4th   5th  
       messages to pagers  
       profile setup   2nd   3rd  
       profiles  
SQLDiag   2nd   3rd   4th  
SQLMaint   2nd   3rd  
SQLMAINT utility   2nd  
SQLPERF command (DBCC), performance monitoring   2nd   3rd  
sqlredis
       installation and  
SQLServer   2nd  
SQLSNMP.DLL file  
SQLXML  
SSL (Secure Sockets Layer)
       encryption  
Standard Edition   2nd  
standard logins  
standby servers, backups   2nd   3rd  
starting SQL Server   2nd   3rd   4th  
starting/stopping servers, Enterprise Manager   2nd  
startup
       Agent  
       configuration  
state options  
statement
       ALTER PROCEDURE   2nd  
statement permissions  
       Enterprise Manager   2nd  
statements
       ALTER VIEW   2nd   3rd  
       BEGIN DISTRIBUTED TRANSACTION  
       BULK INSERT  
               BCP utility and   2nd   3rd   4th   5th   6th   7th   8th  
       CHECK  
       COMMIT  
       CREATE VIEW  
       DBCC CHECKDB  
       DECLARE  
       DROP PROCEDURE  
        EXEC  
               stored procedures  
       GOTO  
       INSERT  
       MDX  
       Profiler and  
       RECONFIGURE WITH OVERRIDE  
       RETURN
               scalar functions  
       ROLLBACK  
       rollback tran  
       SET TRANSACTION ISOLATION LEVEL  
STATIC cursors   2nd  
statistics
       auto-update
               Profiler   2nd  
       Query Analyzer   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
STATISTICS IO option, Query Analyzer   2nd   3rd   4th   5th   6th   7th   8th  
STATISTICS TIME option, Query Analyzer   2nd   3rd   4th   5th   6th   7th  
statistics, indexes   2nd   3rd   4th   5th  
       auto-update   2nd   3rd   4th   5th   6th   7th   8th  
        densities   2nd   3rd  
       generating   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th  
       histogram   2nd   3rd   4th   5th   6th  
       maintenance   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th  
       manual update   2nd   3rd   4th  
       rows, estimating   2nd   3rd   4th  
statistics, VLDB   2nd  
status
       internal status codes   2nd  
       stored procedures   2nd   3rd   4th  
steps, Jobs   2nd   3rd  
        multistep jobs   2nd  
stopping SQL Server   2nd   3rd   4th  
storage   2nd  
       databse engine   2nd   3rd  
       extent  
       IAM  
       indexes  
Storage Design Wizard, AS  
storage design, OLAP databases   2nd   3rd   4th   5th  
storage structures   2nd  
storage types
       BCP utility and   2nd   3rd   4th   5th   6th   7th   8th  
store and forward data distribution model  
stored procedures  
       advantages   2nd   3rd   4th   5th  
       autostart stored procedures   2nd   3rd   4th   5th   6th   7th  
       BCP utility   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       cascading updates  
       coding guidelines   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       creating   2nd   3rd   4th   5th   6th   7th  
       CURSOR variables   2nd   3rd   4th   5th   6th   7th   8th  
       cursors   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th  
               deallocating  
       debugging   2nd  
               Query Analyzer   2nd   3rd  
               Visual BASIC   2nd   3rd  
               Visual Studio   2nd   3rd  
       dynamic SQL   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       editing
               Enterprise Manager  
       EXEC statement  
       executing   2nd   3rd   4th   5th   6th   7th  
       executions
               publishing  
       extended   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
               functions and  
       groups   2nd   3rd  
       input parameters   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       INSERT statement  
       integration and  
       limitations   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       linked servers
               executing  
               system-stored   2nd  
       linked servers and  
       listing  
       login management   2nd  
       Mail   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd  
       modifying   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       modular programming and  
        name resolution
               deferred   2nd   3rd   4th   5th   6th   7th   8th   9th  
       naming standards   2nd  
       nested   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       Notification Services and   2nd  
       objects
               identifying those references   2nd   3rd   4th  
       output parameters   2nd   3rd  
       parameters
               default values   2nd   3rd   4th   5th  
       performance   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th  
       performance improvements  
       portability and  
       procedure cache   2nd   3rd   4th   5th  
       Profiler and   2nd  
       queries
               caching and   2nd  
       Query Analyzer   2nd   3rd   4th  
       query plans
               automatic recompilation   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
               forcing recompilation   2nd   3rd   4th   5th   6th   7th   8th  
       recompilation
               minimizing   2nd   3rd   4th   5th   6th   7th  
               monitoring   2nd   3rd   4th  
       recursive   2nd   3rd   4th   5th   6th   7th  
       remote   2nd  
       replication   2nd  
       resultsets
               INSERT statement  
       rewriting as functions   2nd   3rd   4th  
       shared-query plans   2nd   3rd   4th   5th   6th  
       source code  
               Query Analyzer   2nd   3rd   4th  
       sp_password  
       sp_publication_validation   2nd  
       sp_replcounters  
       status   2nd   3rd   4th  
       system administration  
       system stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th  
               system table queries   2nd  
       system-stored
               common  
       system-stored procedures   2nd   3rd   4th  
       table datatype   2nd   3rd   4th   5th   6th   7th  
       tables   2nd  
       temporary tables   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
               performance tips   2nd   3rd   4th   5th   6th   7th   8th  
       text, viewing  
       transactions
               calling from   2nd   3rd   4th   5th  
       transactions and   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
       USE statement  
       viewing   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       WITH RECOMPILE option  
       XML   2nd   3rd   4th   5th   6th  
       xp sendmail  
stored-procedures
       database roles  
       permissions  
Stream Aggregate operator, Query Analyzer  
string functions   2nd   3rd   4th  
strings
       concatenation  
       empty  
       NULL  
Structured Query Language (SQL)  
subqueries
       correlated   2nd  
       materialized  
       query optimization and   2nd   3rd   4th  
       T-SQL   2nd   3rd   4th   5th   6th  
               aggregates  
               as derived tables   2nd  
               joins and   2nd   3rd  
               not exists and   2nd  
               not in and   2nd  
subscribers
       MSsubscriber_info  
       MSsubscriptions  
       replication
               Internet  
       updates
               snapshot replication  
               transactional replication and  
       updating
               replication and   2nd   3rd  
subscription server
       replication   2nd  
subscriptions
       anonymous   2nd  
       FTP configuration   2nd  
       pull   2nd   3rd   4th  
       push   2nd  
       replication   2nd  
       replication and   2nd   3rd  
       replication setup   2nd   3rd   4th   5th   6th  
subscriptions, Notification Services   2nd  
subscriptions, Notification Services and  
subset phrasing , English Query  
SUBSTRING function  
suffixes, naming standards   2nd   3rd  
summary data, denormalization and   2nd  
Support Services folder, Enterprise Manager  
       DTC (Distributed Transaction Coordinator)  
       Full-Text Search  
       SQL Mail  
surrogate primary key
       columns  
swapping  
switches
       format files
               BCP utility   2nd   3rd   4th   5th   6th  
synchronization
       .BCP files  
       articles, replication  
       snapshot agent  
synonyms
       datatypes   2nd  
syntactic transactions, nested  
sysadmin role
       permissions  
syscomments table
       stored procedures
               source code   2nd   3rd  
sysdatabases table  
sysfiles table  
syslockinfo table   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th  
system administration
       system databases   2nd   3rd   4th  
       system tables   2nd   3rd   4th   5th   6th   7th  
               querying   2nd   3rd   4th   5th  
       system-stored procedures   2nd   3rd   4th  
system administrator
       account setup   2nd  
       responsibilities   2nd   3rd  
System Administrators Security Role  
system catalog tables   2nd  
system database
       backups   2nd   3rd  
system databases
       distribution  
       master  
       model  
       msdb  
        restores   2nd   3rd   4th   5th  
       tempdb  
system functions   2nd   3rd  
       system tables  
system requirements
       clients   2nd  
system stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th  
       ANSI-compliant views   2nd   3rd   4th  
       creating   2nd   3rd   4th  
       full-text indexes  
       schema views   2nd  
       sp_recompile   2nd  
       system table queries   2nd  
system tables   2nd   3rd   4th   5th   6th   7th   8th  
       backup tables   2nd  
       log shipping tables   2nd  
       maintenance plan   2nd  
       msdb database   2nd  
       queries   2nd  
       querying  
               information schema views   2nd   3rd  
               metadata functions  
               system functions  
system-stored procedures   2nd   3rd   4th  
       common  
       fixed-server roles and  
       linked servers   2nd  
       SP_CONFIGURE  
       sp_dboption  
system-suppled datatypes  
system-wide table-valued functions   2nd   3rd   4th  
sysusers table  
sysxlogins table
       logins  
sysxlogins tables
       Windows Authentication mode and  



Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net