The Microsoft SQL Server 2000 Performance Optimization an... and over 900,000 other books are available for Amazon Kindle . Learn more

Buy New

Quantity:


	Amazon Prime free trial required. Sign up when you check out. Learn more

Buy Used

Used - Good See details

Price: �1.81

Fulfilled by Amazon

More Buying Choices

Have one to sell? Sell yours here

Share your own customer images

Search inside this book

Start reading The Microsoft SQL Server 2000 Performance Optimization an... on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook [Paperback]

Ken England Microsoft Certified Systems Engineer and a Microsoft Certified Trainer (Author)

RRP:	�46.99
Price:	�39.94 & this item Delivered FREE in the UK with Super Saver Delivery. See details and conditions
Deal Price:
You Save:	�7.05 (15%)
	o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o

In stock.
Dispatched from and sold by Amazon.co.uk. Gift-wrap available.

Want guaranteed delivery by Monday, February 13? Choose Express delivery at checkout. See Details

Formats	Amazon Price		New from	Used from
Kindle Edition	�29.96		--	--
Paperback	�39.94		--	--

Amazon.co.uk Trade-In Store
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Amazon.co.uk Trade-In Store for more details.

› See more product promotions

There is a newer edition of this item:

Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook 1.0 out of 5 stars (1)
�39.89

In stock.

Product details

Paperback: 320 pages
Publisher: Digital Press (10 May 2001)
Language English
ISBN-10: 1555582419
ISBN-13: 978-1555582418
Product Dimensions: 22.9 x 17.8 x 2.5 cm
Amazon Bestsellers Rank: 715,850 in Books (See Top 100 in Books)
- #47 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate

Would you like to update product info or give feedback on images?

See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

› Visit Amazon's Ken England Page

Product Description

Review

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

Product Description

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

See all Product Description

Inside This Book (Learn More)

First Sentence
What is the goal of tuning a SQL Server database? Read the first page

Explore More
Concordance

Tag this product

(What's this?)

Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items.

Customer Reviews

There are no customer reviews yet on Amazon U.K.

5 star:		(0)
4 star:		(0)
3 star:		(0)
2 star:		(0)
1 star:		(0)

Share your experience with this product with others

Create your own review

Most Helpful Customer Reviews on Amazon.com ^(beta)

Amazon.com: 4.8 out of 5 stars (15 customer reviews)

27 of 27 people found the following review helpful:

5.0 out of 5 stars Highly useful for experienced developers, 1 Aug 2001

By Jaewoo Kim "OB-Wan" - Published on Amazon.com

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

What I really like about this book is that it is cheap compared to its competitors. The author does not waste paper with wordy sentences that is only meant to take up space to create a 1500+ book to justify a price.

The author explains three things in depth and better than any books I have ever read (and I have read lot of SQL books): Index optimization, query optimization, and locking.

These three topics are usually for advanced SQL developers who must performance tune a complex database. This book is not for the beginners. Having said this, if you want to be a serious database developer, this book will put you ahead of your competition. I highly recommend it to anyone who wants to be or is a database developer.

16 of 16 people found the following review helpful:

5.0 out of 5 stars If you are a DBA, this is the book, 14 Jun 2001

By Lefty "Lefty" - Published on Amazon.com

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

I have been amazed about how much information is in this book. The writing is clear and concise. The long section that details query tuning was an education in itself.

I finished the book with a clear understanding of the types of queries and how SQL Server uses them.

This book is sitting on my desk now. If you want the information on how to optimize your queries, or the database, this is my recommendation.

8 of 8 people found the following review helpful:

5.0 out of 5 stars Great book. Best if used in pair with inside SQL Server 2000, 20 May 2001

By Jesse Roberge "GreatInca" - Published on Amazon.com

This review is from: The Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook (Paperback)

There is much overlap with the inside sql server 2000 book from microsoft but that book is more a detailed survey with a intuitive technical foucus while this book is a more pratical focus. These two books work together to form the ultimate 'book'. This book covers everything in detail and has many practical expamples, but the examples are not page fillers. It actulaly has many less pages than inside sql server.

› Go to Amazon.com to see all 15 reviews 4.8 out of 5 stars

Were these reviews helpful? Let us know

.jsOffDisplayBlock { display: block; } .jsOffDisplayInline { display: inline; } .jsOffVisibility { visibility: visible; } .jsOnDisplayBlock { display: none; } .jsOnDisplayNoneBlock { display: block; } .jsOnDisplayNoneInline { display: inline; } .jsOnDisplayInline { display: none; } .jsOnVisibility { visibility: hidden; } .jqOnDisplayBlock { display: none; } .jqOnDisplayInline { display: none; } .jqOnVisibility { visibility: hidden; } .jqOnDisplayNoneBlock { display: block; } .jqOnDisplayNoneInline { display: inline; }