Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook
By: and
Sign Up Now!
Already a Member? Log In
You must be logged into UK education collection to access this title.
Learn about membership options,
or view our freely available titles.
- Synopsis
- 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 and discusses the most common issues database administrators (DBAs) face day-to-day*Provides DBAs with solutions actually used by the authors in enterprise environments*Explores new features which add more control but reduce performance
- Copyright:
- 2007
Book Details
- Book Quality:
- Publisher Quality
- Book Size:
- 520 Pages
- ISBN-13:
- 9780080554082
- Related ISBNs:
- 9781555583194
- Publisher:
- Elsevier Science
- Date of Addition:
- 05/11/21
- Copyrighted By:
- Elsevier Science & Technology
- Adult content:
- No
- Language:
- English
- Has Image Descriptions:
- No
- Categories:
- Nonfiction, Computers and Internet
- Submitted By:
- Bookshare Staff
- Usage Restrictions:
- This is a copyrighted book.