The SYBASE SQL Server Survival Guide
Jim Panttaja, Mary Panttaja · John Wiley & Sons, Inc. eBooks · 1996
From the Publisher: 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; and, 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.