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

Jeffrey R. Garbus; Robert D. Schneider

Softcover

ISBN 10: 0130122564 ISBN 13: 9780130122568

Publisher: Prentice Hall Ptr

Synopsis

Explains the intricacies of the SQL Server engine necessary to produce fast database applications. For database and system administrators who already understand the engine architecture. The CD-ROM contains a computer-based training course and SQL Relay. Annotation c. by Book News, Inc., Portland, Or.

About this title

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.

Edition details

• Publisher: Prentice Hall Ptr
• Language: English
• ISBN 10: 0130122564
• ISBN 13: 9780130122568
• Binding: Paperback
• Edition number: 2
• Number of pages: 548