Sybase DC35823-01-1500-04 - Manual (Page 10)

x Adaptive Server Enterprise
• Locking – describes how the various locking schemas can be used for
improving performance in Adaptive Server.
• Optimizer and Abstract Plans – describes how the optimizer
processes queries and how abstract plans can be used to change some
of the optimizer plans.
• Monitoring and Analyzing – explains how statistics are obtained and
used for monitoring and optimizing performance.
• Quick Reference Guide – provides a comprehensive listing of the names
and syntax for commands, functions, system procedures, extended system
procedures, datatypes, and utilities in a pocket-sized book.
• Reference Manual – is a series of four books that contains the following
detailed Transact-SQL
®
information:
• Building Blocks – Transact-SQL datatypes, functions, global
variables, expressions, identifiers and wildcards, and reserved words.
• Commands – Transact-SQL commands.
• Procedures – Transact-SQL system procedures, catalog stored
procedures, system extended stored procedures, and
dbcc stored
procedures.
• Tables – Transact-SQL system tables and dbcc tables.
• System Administration Guide – provides in-depth information about
administering servers and databases. This manual includes instructions
and guidelines for managing physical resources, security, user and system
databases, and specifying character conversion, international language,
and sort order settings.
• System Tables Diagram – illustrates system tables and their entity
relationships in a poster format. Available only in print version.
• Transact-SQL User’s Guide – documents Transact-SQL, Sybase’s
enhanced version of the relational database language. This manual serves
as a textbook for beginning users of the database management system.
This manual also contains descriptions of the
pubs2 and pubs3 sample
databases.
• Using Adaptive Server Distributed Transaction Management Features –
explains how to configure, use, and troubleshoot Adaptive Server DTM
features in distributed transaction processing environments.