The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook

By: Ken England

Write A Review

Paperback | 1 March 2001

At a Glance

Paperback
406 Pages

Dimensions(cm)
25.4 x 17.78 x 2.11

Paperback

$183.75

or 4 interest-free payments of $45.94 with

Ships in 10 to 15 business days

Learn from a SQL Server performance authority how to make your database run at lightning speed.

Ken England's SQL Server 6.5 Performance Optimization and Tuning Handbook is recognized by SQL Server administrators as the indispensable guide to tuning and optimization. Now he's revised the book for Microsoft's new SQL Server 2000, the most advanced and powerful version yet of SQL Server, which takes full advantage of Windows 2000's new processing capabilities. The book details the factors that determine database performance and offers readers tools, techniques and best practices they can use to tweak and tune SQL Server's configuration and operation. Readers will learn how to enhance performance through good physical design and effective internal storage structures. The book spells out methods for creating efficient indexes and techniques for tuning SQL Server's new query optimizer.

A new edition of the authoritative and bestselling guide, SQL Server 6.5 Performance Optimization and Tuning Handbook, 1555581803Targets SQL Server 2000Helps IT professionals run SQL Server more powerfully and efficiently and optimize it for e-commerce and knowledge management

Industry Reviews

This book provides tools, techniques, and best practices that you can use to tune SQL Server's configuration and operation.
-SQL Server

This book is a real gem and derserves a wide audience - Joe Karam, MCSD, MCDBA, MCT

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Database Software SQL Server & MS SQL Computer Programming & Software Development Database Programming Operating Systems Data Capture & Analysis

Preface	p. xi
Acknowledgments	p. xiii
Introducing Performance Tuning and Physical Database Design	p. 1
What is performance tuning?	p. 1
The physical database design process	p. 3
Where to next?	p. 10
SQL Server Storage Structures	p. 11
Introduction	p. 11
Databases and files	p. 11
Creating databases	p. 14
Increasing the size of a database	p. 19
Decreasing the size of a database	p. 21
Modifying filegroup properties	p. 26
Setting database options	p. 27
Displaying information about databases	p. 30
System tables used in database configuration	p. 32
Units of storage	p. 35
Database pages	p. 37
Looking into database pages	p. 42
Pages for space management	p. 45
The BankingDB database	p. 49
Indexing	p. 51
Introduction	p. 51
Data retrieval with no indexes	p. 51
Clustered indexes	p. 52
Nonclustered indexes	p. 57
The role of indexes in insertion and deletion	p. 59
A note about updates	p. 69
So how do you create indexes?	p. 70
Dropping and renaming indexes	p. 84
Displaying information about indexes	p. 84
Creating indexes on views	p. 95
Creating indexes with computed columns	p. 97
Using indexes to retrieve data	p. 98
Choosing indexes	p. 110
The Query Optimizer	p. 119
Introduction	p. 119
When is the query optimized?	p. 120
Query optimization	p. 121
SQL Server 2000 and Windows 2000	p. 227
SQL Server 2000 and CPU	p. 227
SQL Server 2000 and memory	p. 243
SQL Server 2000 and disk I/O	p. 257
Transactions and Locking	p. 275
Introduction	p. 275
Why a locking protocol?	p. 276
The SQL server locking protocol	p. 278
SQL Server locking in action	p. 314
Uncommitted data, repeatable reads, phantoms, and more	p. 319
Application resource locks	p. 327
A summary of lock compatibility	p. 327
Monitoring Performance	p. 329
Introduction	p. 329
System stored procedures	p. 329
System monitor, performance logs, and alerts	p. 331
The SQL Profiler	p. 335
Index Tuning wizard	p. 349
Query analyzer	p. 358
A Performance Tuning Checklist	p. 361
System resource use	p. 361
Choosing efficient indexes	p. 362
Helping the Query Optimizer	p. 364
Avoiding lock contention	p. 364
Database integrity	p. 367
Database administration activities	p. 367
Archiving data	p. 368
Read only report databases	p. 368
Denormalization	p. 369
Bibliography	p. 371
Index	p. 373
Database Technologies	p. 391
Table of Contents provided by Syndetics. All Rights Reserved.

The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

The Art of Explanation

How to Communicate with Clarity and Confidence

Designing Data-Intensive Applications

The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Statistics and Data Handling for Biologists

A Student's Guide

Statistics and Data Handling for Biologists

A Student's Guide

Advanced Analytics for Industry 4.0

Technology Industries

Mathematical Foundations of Blockchains

Engineering Principles, Volume 2

Navigating the AI Frontier in Business

Balancing Economy, Ecology, and Inclusion

Stochastic Control in Energy, Environmental and Resource Management Applications

Emerging Methodologies and Applications in Modelling, Identification and Control

Architecting an Apache Iceberg Lakehouse

A Scalable, Open-Source Data Platform

Proceedings of the 6th International Conference on Big Data Analytics for Cyber-Physical System in Smart City, Volume 1

BDCPS 2024, December 7-8, Ji'an, China

Python All-in-One For Dummies

3rd Edition

Hands-On Programming with R

Write Your Own Functions and Simulations

Social Research Methods

4th Edition

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

The Value of People Analytics

Using HR Data to Drive Business Results

Microsoft Excel 365 Bible

Bible

Microsoft 365 Access For Dummies

Access for Dummies

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Coding All-in-One For Dummies

2nd Edition

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Data-driven BIM for Energy Efficient Building Design

1st Edition

Database Systems 6ed

A Practical Approach to Design, Implementation, and Management, Global Edition

Artificial Intelligence for HR

Use AI to Support and Develop a Successful Workforce

SQL Essentials For Dummies

For Dummies (Computer/Tech)

This product is categorised by