A complete, hands-on guide for database programmers and developers "In the past, the developer needed access to a great collection of experience and folklore to be successful with SQL Server. The goal of this book is to provide the lessons that we have learned...to help you avoid some of the common (and not so common) mistakes that affect most projects. " --the Authors If you are a database developer or programmer working with Sybase System 11 SQL Server, this book can save you many frustrating hours of trial and error while schooling you in hard-to-find techniques for streamlining the development process. Acting as your private tutors, Jim and Mary Panttaja, founders of one of the nation's most prestigious client/server computing and relational database consulting groups, and Judy Bowman, an SQL educator, supply you with a wealth of tips and tricks for developing powerful business applications with Sybase SQL Server. Examining both underlying theory and day-to-day operations, The Sybase SQL Server Survival Guide gives you: * Practical guidance on client/server application architecture, locking, transaction management, concurrency control, and other key technical issues * Expert tips on database design, index selection, tuning, code generation, and many more common (and uncommon) problems * Comprehensive directions on getting the most out of new System 11 features like named caches, variable I/O, LRU and MRU cache strategy, and heap table partitioning A gold mine of valuable tricks and tips on everything from administration and performance tuning to application partitioning and troubleshooting, this book is certain to become one of the most-used volumes in your working library.