Optimizing Sql Server 7 : Planning and Building a High-Performance Database (Prentice Hall Series on Microsoft Technologies)

Reviews
From the Back Cover
Plan it right for optimum performance - from the ground up!
Make your database applications:
More productive
More reliable
Simpler to use
With Optimizing SQL Server 7, you'll learn how to develop the blueprint for a Microsoft SQL Server database that will grow with your unique requirements.

*Efficient Design - Master the three forms of normalization and when to use them. Discover strategies that lead to a successful index, including structure, columns, keys, data types, and clustering. Unlock the power of the Microsoft SQL Server optimizer to get the highest degree of performance.

*Efficient Access - Use stored procedures and triggers to make transactions quick and easy for users at all levels. You'll learn to minimize network traffic by taking advantage of Microsoft SQL Server's facility with joins, batches, searches, and tables. Get insider's tips on powerful features including transactions, cursors, and concurrency.

*Ongoing Performance Tuning - Master the secrets of disk management and replication to optimize your database engine's capacity.

*Testing for Success - Learn the essentials of a successful testing environment, and the planning strategies for an effective roll-out.

*Learn from Experience - Case studies show how a range of organizations have used Microsoft SQL Server to maximize their database power. You may recognize situations that you already faced, now see the expert's solutions.

*Optimizing SQL Server is packed with experience and tips, but not just for application developers. Database and system administrators, systems analysts, and system administrators can all learn the basics of Microsoft SQL Server applications, without having to master all the intricacies of the Microsoft SQL Server engine.

About the Author
ROBERT D. SCHNEIDER is a co-founder of AffiniTerm, Inc. Formerly Director of Client Services for Visigenic Software and a senior member of Informix Software's consulting staff, he provided database and application expertise to numerous information technology leaders around the world. He is the author of the first edition of this work and of Optimizing Informix Applications. He can be reached at robs@affiniterm.com
JEFFREY R GARBUS is CEO of Soaring Eagle Consulting, Ltd., a consulting company specializing in RDBMS solutions. He is the author of eight database books including five on SQL Server. His wide range of experience includes teaching database courses, writing numerous articles and speaking at professional meetings. He can be reached at jeffg@soaringeagleltd.com

Back to SQL : Server - Microsoft
Back to Databases
Back to Main Index