Index P


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

package execution utilities, DTS   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
packages
       MTS
               security  
       MTS components   2nd   3rd  
packets
       size
               configuration   2nd   3rd  
page faulting  
page splits   2nd   3rd   4th   5th  
page splits, clustered tables  
page-level locking   2nd   3rd  
pagers , SQLAgentMail  
pages  
pages, databases
       BCM pages   2nd   3rd  
       content   2nd   3rd   4th   5th   6th   7th   8th  
       data pages  
               data rows   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  
               page header   2nd   3rd  
               row offset table   2nd   3rd   4th  
       DCM pages   2nd  
       IAM   2nd   3rd   4th   5th   6th   7th  
       images   2nd   3rd   4th   5th   6th   7th  
       index pages   2nd   3rd   4th   5th   6th   7th   8th  
       PFS   2nd  
       space allocation   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th  
       text   2nd   3rd   4th   5th   6th   7th  
       types   2nd  
pages, storage  
parallel loading of tables, BCP utility   2nd   3rd   4th   5th   6th  
parallel query processing   2nd   3rd   4th   5th   6th   7th   8th  
parallelism
       cost threshold, configuration   2nd  
       max degree, configuration   2nd  
Parallelism icon, Query Analyzer  
Parameter Table Scan icon, Query Analyzer  
parameters
       input parameters
               stored procedures   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       obsolete  
       output
               sp_executesql   2nd   3rd   4th  
       output parameters
               stored procedures   2nd   3rd  
       passing object names as   2nd   3rd  
       stored procedures
               default values   2nd   3rd   4th   5th  
       wildcards, stored procedures and   2nd   3rd  
partial backups
       secondary data files  
PARTIAL option, RESTORE DATABASE command  
partial restores , databases   2nd  
partial transactions  
Partition Wizard, AS  
partitioned views   2nd   3rd   4th  
partitioning
       distributed partitioned views  
       Distributed Partitioned Views   2nd  
       distributed transactions  
       Local Partitioned Views  
       performance monitoring and  
       vertical data partitioning   2nd  
       VLDB   2nd  
               horizontal   2nd  
               vertical   2nd   3rd  
partitions
       AS  
       cubes   2nd  
       secondary data files and  
       views
               distributed   2nd   3rd  
               modifying data   2nd  
passing
       object names as parameters   2nd   3rd  
passwords
       linked servers  
       sa account  
PathPing utility  
pausing SQL Server   2nd   3rd   4th  
PC LAN computing   2nd  
Per Processing licensing  
Per Seat licensing  
PERFMON command (DBCC), performance monitoring  
performance
       bottlenecks, Profiler   2nd  
       design and   2nd   3rd  
       file groups and   2nd   3rd   4th  
       replication   2nd  
       stored procedures   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  
       temporary tables   2nd   3rd   4th   5th   6th   7th   8th  
performance condition alerts, Agent  
Performance Monitor
       Alert view  
       Chart view  
       counters   2nd   3rd  
       disk activity   2nd   3rd  
       disk system   2nd   3rd   4th   5th   6th   7th   8th   9th  
       locks  
               number of   2nd   3rd  
       Log view  
       memory   2nd   3rd   4th   5th   6th  
       MSSQL Cache Manager object   2nd   3rd  
       network interface   2nd   3rd   4th   5th   6th   7th   8th   9th  
       overview  
       performance counters   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th  
       performance objects   2nd   3rd   4th  
       procedure cache   2nd  
       processors   2nd   3rd   4th   5th   6th   7th  
       replication and   2nd  
       Report Monitor  
        user -defined counters   2nd   3rd  
       users  
       values   2nd   3rd  
       views   2nd  
performance monitor objects
       Notification Services and  
performance monitoring   2nd  
       DBCC   2nd   3rd   4th   5th   6th   7th  
       distributed transactions   2nd  
       Network Monitor Agent  
       non-clustered indexes  
       overview   2nd   3rd  
       partitioning and  
       SNMP   2nd  
       tables and  
       transaction logs  
       Windows
               counters   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  
performance testing environment   2nd   3rd  
permissions
       application roles   2nd  
       authentication methods and   2nd  
       databases
               Notification Services   2nd   3rd  
       DELETE  
       DENY command  
       DML  
       extended stored procedures  
       fixed roles  
       GRANT command  
       implicit  
       INSERT  
       management   2nd   3rd   4th   5th   6th   7th   8th  
       object owners   2nd  
       object permissions   2nd  
       pre-defined  
       public
               granting  
       REVOKE command  
       SELECT  
       statement permissions  
       stored procedures  
       T-SQL   2nd  
       UPDATE  
       user-defined functions  
       user-defined roles
               granting  
       views  
Personal Edition   2nd  
       licensing  
PFS (Page Free Space)   2nd  
PFS (Page Free Space) page  
phantom data, transactions  
phantom reads, isolation levels  
physical operators
       icons
               Query Analyzer   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
ping utility  
pinning tables  
Pivot Table Service
       OLAP cubes  
platform matrix  
point-in-time recovery   2nd  
POP3/SMTP, Mail setup and   2nd   3rd   4th   5th   6th   7th  
portability
       database design and  
portability, stored procedures and  
post-installation configuration   2nd   3rd  
post-upgrade tasks   2nd  
pre-production testing environment   2nd   3rd  
precedence
       binding
               defaults   2nd   3rd  
               rules   2nd   3rd  
predefined permissions  
predicate transitivity, query optimization and   2nd   3rd  
prefixes
       file formats, BCP utility and   2nd   3rd   4th  
prefixes, naming standards   2nd   3rd  
prepositional phrases, English Query  
presenting data, AS   2nd   3rd  
primary data file   2nd   3rd   4th  
primary files  
       groups   2nd  
primary key
       referential integrity  
PRIMARY KEY constraints   2nd  
print statement
       T-SQL   2nd  
priority boost, configuration   2nd  
PROCCACHE command (DBCC), performance monitoring   2nd   3rd  
procedural data integrity  
procedure cache, Performance Monitor   2nd  
procedure cache, stored procedures   2nd   3rd   4th   5th  
procedures   [See also stored procedures]
       aa   [See also stored procedures]
       stored procedures
               linked servers  
               replication   2nd  
       stored-procedures
               permissions  
        system-stored procedures   2nd   3rd   4th  
               common  
process management  
       server threads   2nd   3rd   4th   5th  
process requirements  
processing instructions, XML  
processor licensing  
Processor licensing  
processors
       client requirements  
       Performance Monitor and   2nd   3rd   4th   5th   6th   7th  
production environment   2nd   3rd  
production-fix testing environment   2nd  
Profiler   2nd   3rd   4th   5th   6th  
       adhoc queries   2nd  
       application process   2nd   3rd  
       architecture   2nd   3rd  
       auditing   2nd  
       bottlenecks   2nd  
       Index Tuning Wizard and  
       locking and   2nd   3rd   4th   5th  
       scenarios   2nd   3rd   4th   5th   6th   7th   8th   9th  
       statistics, auto-update   2nd  
       stored procedures   2nd  
       Trace and  
       traces
               creating   2nd   3rd  
               data columns   2nd   3rd   4th   5th  
               events   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
               exporting   2nd   3rd   4th   5th  
               importing   2nd   3rd   4th   5th   6th   7th   8th  
               Index Tuning Wizard  
               properties   2nd   3rd   4th  
                replaying   2nd   3rd  
               running, monitoring   2nd   3rd  
               saving   2nd   3rd   4th   5th  
               server side   2nd   3rd  
               server side, stopping   2nd   3rd  
       Windows 98 and  
       Windows Me and  
Profilers
       filters  
profiles
       SQLAgentMail  
profiles, e-mail
       setup   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
programming constructs   2nd   3rd  
       batches   2nd   3rd  
       BREAK statement   2nd  
       comments   2nd   3rd  
       CONTINUE statement   2nd  
       DCL  
       DDL  
       DML  
       EXECUTE statement   2nd   3rd  
       IF statement   2nd  
       RETURN statement   2nd  
        variables
               local   2nd   3rd   4th   5th  
       WHILE statement   2nd  
properties
       ACID properties  
       alerts
               Agent   2nd   3rd  
       columns
               T-SQL   2nd   3rd   4th  
       database files  
       Enterprise Manager
               viewing   2nd  
       functions
               parameters  
       IDENTITY   2nd  
       Jobs, Agent   2nd  
       MTS components   2nd   3rd   4th  
       NOT NULL   2nd  
       NULL   2nd  
       traces
               Profiler   2nd   3rd   4th  
       user-defined functions  
protocols
       Client Network Utility  
       networks
                clients   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st  
proxy accounts
       Agent   2nd  
proxy server  
public permissions
       granting  
publication server
       log reader agent  
       replication  
publications
       FTP configuration   2nd  
       replication  
       replication setup   2nd   3rd   4th   5th  
publications, replication
       articles  
publishers
       MSpublication_access  
       MSpublisher_databases  
       TCP/IP configuration  
Publishers folder, Replication Monitor  
publishing
       enabling
               replication setup   2nd   3rd   4th  
       stored procedure executions  
publishing subscriber scenario   2nd  
pull subscriptions   2nd  
       anonymous subscriptions   2nd  
purging
       VLDB data   2nd  
push subscriptions   2nd  
       distribution agent  
       merge agents  



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

Similar book on Amazon

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