Developing Client/Server Systems Using Sybase SQL Server System 11

Create databases and develop business client/server applications using Sybase Server System 11 The success—or failure—of your client/server application depends on your ability to adapt an existing tool to new uses. Covering the new Sybase SQL Server 11, this guide helps you keep up with the ever-changing demands of distributed data applications and database issues. After a quick review of basic client/server concepts, this book shows you how to implement each concept using the Sybase SQL language. It examines the internals of the SQL Server environment, then proceeds to focus on topics that are needed to build successful client/server applications . This development guide covers stored procedures, triggers, query optimization, ANSI SQL, Transact SQL, caching, transaction logs, environment variables, table partitioning, cursors, and other features that will help you build fast and efficient client/server applications. Completely up-to-date, this book covers all of the latest features of Sybase SQL Server 11, including improved administration, utilities, and performance as well as specially enhanced networking capabilities. A comprehensive tutorial shows you how to install and configure SQL Server quickly, and to develop real world applications. Practical lessons learned from successful client/server development projects are included in this guide.