Microsoft SQL Server 2000 Unleashed (2nd Edition)
| [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 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
|