Table of Contents

Chapter 1—Overview of Client/Server
Chapter 2—Understanding the Sybase Client/Server Architecture
Chapter 3—Introduction to Transact-SQL
Chapter 4—Transact-SQL Datatypes
Chapter 5—Creating and Altering Database Objects
Chapter 6—Transact-SQL Programming Constructs
Chapter 7—Transact-SQL Program Structures
Chapter 8—Transaction Management
Part III—Performance and Tuning

Chapter 9—Defining Performance Expectations and Variables
Chapter 10—Understanding SQL Server Storage Structures
Chapter 11—Designing Indexes for Performance
Chapter 12—Understanding the Query Optimizer
Chapter 13—Stored Procedure Optimization
Chapter 14—Analyzing Query Plans
Chapter 15—Locking and Performance
Chapter 16—Overriding the SQL Server Optimizer
Chapter 17—Database Design and Performance
Chapter 18—Database Object Placement and Performance
Chapter 19—Application Design for Performance
Chapter 20—Advanced Transact-SQL Programming
Chapter 21—Miscellaneous Performance Topics
Chapter 22—Common Performance and Tuning Problems
Part IV—System Administration
Chapter 24—SQL Server Installation and Connectivity
Chapter 25—Defining Physical and Mirror Devices
Chapter 26—Defining, Altering, and Maintaining Databases and Logs
Chapter 27—Security and User Administration
Chapter 28—Database Logging and Recovery
Chapter 29—Backing Up and Restoring Databases and Transaction Logs
Chapter 30—Configuring and Tuning the SQL Server
Chapter 31—Optimizing SQL Server Configuration Options
Chapter 32—Measuring Performance
Chapter 33—Remote Server Management
Chapter 34—Defining Systems Administration and Naming Standards
Chapter 35—Administering Very Large SQL Server Databases

Part V—Introduction to Open Client Programming

Chapter 36—DB-Library Programming
Chapter 37—ct-Library Programming
Chapter 38—ODBC Programming

To Download this E-Book Click Here.