Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook

By: Ken England

Write A Review

Paperback | 1 March 2001

At a Glance

Paperback
320 Pages

Dimensions(cm)
17.78 x 24.13 x 1.91

Paperback

$257.99

or 4 interest-free payments of $64.50 with

or

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 $79.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.

More in Database Programming

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Paperback

RRP $125.75

$60.99

51%
OFF

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

Paperback

RRP $85.75

$43.75

49%
OFF

SQL Tuning

O'Reilly Ser.

Paperback

RRP $75.99

$39.75

48%
OFF

97 Things Every Programmer Should Know

OREILLY

Paperback

RRP $76.00

$39.75

48%
OFF

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Paperback

RRP $125.75

$60.99

51%
OFF

Efficient MySQL Performance

Best Practices and Techniques

Paperback

RRP $125.75

$60.99

51%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

Domain-Specific Small Language Models

Hardcover

$153.75

Oracle PL/SQL Programming

Paperback

RRP $152.00

$89.99

41%
OFF

MySQL in a Nutshell

A Desktop Quick Reference

Paperback

RRP $66.75

$34.99

48%
OFF

Head First PHP & MySQL

A Brain-friendly Guide

Paperback

RRP $104.75

$51.75

51%
OFF

SQL for Data Analytics - Fourth Edition : Analyze data effectively, uncover insights and master advanced SQL for real-world applications - Jun Shan

$47.75

50%
OFF

Transact-SQL Cookbook

Cookbooks Ser.

Paperback

RRP $76.00

$39.75

48%
OFF

Web Database Applications with PHP and MySQL 2e

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Mastering Oracle SQL 2e

O'Reilly Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle PL/SQL Best Practices

O'Reilly Ser.

Paperback

RRP $57.00

$30.75

46%
OFF

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Paperback

RRP $38.00

$21.75

43%
OFF

PHP & MySQL

The Missing Manual

Paperback

RRP $76.00

$39.75

48%
OFF

SQL and Relational Theory, 3e

Paperback

RRP $76.00

$39.75

48%
OFF

Using SQLite

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Perl Programming in easy steps

In Easy Steps

Paperback

RRP $55.99

$54.99

Rails, Angular, Postgres and Bootstrap

Powerful, Effective, Efficient, Full-Stack Web Development

Paperback

RRP $75.95

$34.99

54%
OFF

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.

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 Database Programming

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

SQL Tuning

O'Reilly Ser.

97 Things Every Programmer Should Know

OREILLY

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Efficient MySQL Performance

Best Practices and Techniques

SQL Pocket Guide

A Guide to SQL Usage

Domain-Specific Small Language Models

Oracle PL/SQL Programming

MySQL in a Nutshell

A Desktop Quick Reference

Head First PHP & MySQL

A Brain-friendly Guide

SQL for Data Analytics - Fourth Edition

Analyze data effectively, uncover insights and master advanced SQL for real-world applications

Sams Teach Yourself SQL in 10 Minutes a Day

5th edition

Learning Oracle PL/SQL

Learning Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Web Database Applications with PHP and MySQL 2e

OREILLY

Mastering Oracle SQL 2e

O'Reilly Ser.

Oracle PL/SQL Best Practices

O'Reilly Ser.

LINQ Pocket Reference

Pocket Reference (O'Reilly)

PHP & MySQL

The Missing Manual

SQL and Relational Theory, 3e

Using SQLite

OREILLY

Perl Programming in easy steps

In Easy Steps

Rails, Angular, Postgres and Bootstrap

Powerful, Effective, Efficient, Full-Stack Web Development

This product is categorised by