Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

By: Ken England, Gavin JT Powell

Write A Review

Paperback | 1 April 2007

At a Glance

Paperback
520 Pages

Dimensions(cm)
23.5 x 19.1 x 2.79

Paperback

$225.75

or 4 interest-free payments of $56.44 with

Aims to ship in 10 to 15 business days

Database professionals will find that this new edition aids in mastering the latest version of Microsoft's SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.

Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.

* Identifies the most common issues DBAs face day to day for easy reference
*Provides DBAs with solutions actually used by the authors in enterprise environments to resolve common and specialized problems to optimization issues.
* Addresses issues that have been introduced by new features which can add more control but reduce performance.

Shipping

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

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.Business Applications Databases Database Software SQL Server & MS SQL

Introduction and Acknowledgements
Performance and SQL Server 2005
Logical database design for performance
Physical database design
SQL Server storage structures
Indexing
Basic query tuning
What is query optimization?
Investigating and influencing the optimizer
SQL Server 2005 and Windows 2003
Transactions and locking
Performance and architectural choices
Monitoring performance Appendices
Syntax Conventions
Database Scripts
Performance Strategies and Tuning Checklist
Table of Contents provided by Publisher. All Rights Reserved.

Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Python All-in-One For Dummies

3rd Edition

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Database Systems for Advanced Applications

29th International Conference, DASFAA 2024, Gifu, Japan, July 2-5, 2024, Proceedings, Part V

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part II

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part IV

Advanced Data Mining and Applications

20th International Conference, ADMA 2024, Sydney, NSW, Australia, December 3-5, 2024, Proceedings, Part I

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

SPSS Survival Manual

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

Social Research Methods

4th Edition

Data and Analytics Strategy for Business

Unlock Data Assets and Increase Innovation with a Results-Driven Data Strategy

R for Data Science

Import, Tidy, Transform, Visualize, and Model Data

Generative Deep Learning

Teaching Machines To Paint, Write, Compose, and Play

Data Pipelines Pocket Reference

Moving and Processing Data for Analytics

Don't Make Me Think, Revisited

A Common Sense Approach to Web Usability

The Digital Humanities Coursebook

An Introduction to Digital Methods for Research and Scholarship

Mastering Shiny

Build Interactive Apps, Reports, and Dashboards Powered by R

Architecting Data and Machine Learning Platforms

Enable Analytics and Ai-Driven Innovation in the Cloud

Learning Spark

Lightning-Fast Data Analytics

Python in a Nutshell

A Desktop Quick Reference

Data Science from Scratch

First Principles with Python

Practical Linear Algebra for Data Science

From Core Concepts to Applications Using Python

Data Analytics for Accounting ISE

3rd Edition

Intro to Python for Computer Science and Data Science

Learning to Program with AI, Big Data and The Cloud, Global Edition

This product is categorised by