02430nam a2200313 a 4500 1/45053 140724s2007 us 001 0 eng 9781555583194 (electronic bk.) 1555583199 9780080554082 0080554083 48011 OPELS eng OPELS OCLCG OCLCQ DKDLA E7B UMI DEBSZ OCLCQ GR-PeUP England, Ken, 1955- Microsoft SQL Server 2005 performance optimization and tuning handbook [electronic resource] / Ken England and Gavin J.T. Powell. Boston, Mass. ; Oxford : Digital, 2007. 1 online resource (xvi, 499 p.) : ill. Database professionals will find that this new edition aids in mastering the latest version of Microsofts 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. SQL server. Client/server computing. Relational databases. Electronic books. Powell, Gavin. INST UNIPILB EBOOKS 20140724 00b48011 00b48011 ONLINE 0 ScienceDirect http://www.sciencedirect.com/science/book/9781555583194 /webopac/covers/03/48011_9781555583194.jpg (electronic bk.) /webopac/covers/03/48011_1555583199.jpg /webopac/covers/03/48011_9780080554082.jpg /webopac/covers/03/48011_0080554083.jpg