Sybase DC35823-01-1500-04 manual 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.

x Adaptive Server Enterprise