|
Showing 1 - 3 of
3 matches in All Departments
|
The Gate Was Open
Ken England
|
R514
R433
Discovery Miles 4 330
Save R81 (16%)
|
Ships in 10 - 15 working 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.
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
|
You may like...
Merry Christmas
Mariah Carey, Walter Afanasieff, …
CD
R122
R112
Discovery Miles 1 120
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
|