SQL server 2005 practical troubleshooting; the data base engine. (CD-ROM included).0321447743SQL server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. 2005 practical troubleshooting; the data base engine. (CD-ROM CD-ROM: see compact disc. CD-ROM in full compact disc read-only memory Type of computer storage medium that is read optically (e.g., by a laser). included) Ed. by Ken Henderson Addison-Wesley 2007 461 pages $54.99 Paperback QA76.9 Insider Henderson and a team of developers and support engineers give novice to advanced users exceptional access to diagnostic and troubleshooting tools here. Each chapter starts with the basics on the architecture of a key server component, then goes deeper into details starting with the most common problems user encounter. In the process Henderson covers issues with waiting and blocking (including identifying sources and resource type specifics), data corruption Data corruption refers to errors in computer data that occur during transmission or retrieval, introducing unintended changes to the original data. Computer storage and transmission systems use a number of measures to provide data integrity, the lack of errors. and recovery (including storage internals, data recovery best practices and database consistency errors), memory (including Windows, SQLOS and SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. memory management), procedure caches (including common problems and solutions), query processors (including best practices), service crashes and other critical failures, the product Service Broker, SQLOS and scheduling (including configuration), Tempdb (including how space is consumed) and clustering (including getting performance up to acceptable levels). The CD-ROM contains a selection of tools, sample code and scripts. ([c]20072005 Book News, Inc., Portland, OR) |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion