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."
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 bookis certain to become one of the most-used volumes in your working library.