Microsoft SQL Server 2005 performance optimization and tuning handbook:
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 qui...
Gespeichert in:
Beteilige Person: | |
---|---|
Weitere beteiligte Personen: | |
Format: | Elektronisch E-Book |
Sprache: | Englisch |
Veröffentlicht: |
Boston, Mass. ; Oxford
Digital
2007
|
Schlagwörter: | |
Links: | https://learning.oreilly.com/library/view/-/9781555583194/?ar |
Zusammenfassung: | 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. |
Beschreibung: | Print version record |
Umfang: | 1 Online-Ressource (xvi, 499 Seiten) illustrations |
ISBN: | 9781555583194 1555583199 9780080554082 0080554083 |
Internformat
MARC
LEADER | 00000cam a22000002 4500 | ||
---|---|---|---|
001 | ZDB-30-ORH-051697114 | ||
003 | DE-627-1 | ||
005 | 20240228114133.0 | ||
007 | cr uuu---uuuuu | ||
008 | 200417s2007 xx |||||o 00| ||eng c | ||
020 | |a 9781555583194 |9 978-1-55558-319-4 | ||
020 | |a 1555583199 |9 1-55558-319-9 | ||
020 | |a 9780080554082 |9 978-0-08-055408-2 | ||
020 | |a 0080554083 |9 0-08-055408-3 | ||
035 | |a (DE-627-1)051697114 | ||
035 | |a (DE-599)KEP051697114 | ||
035 | |a (ORHE)9781555583194 | ||
035 | |a (DE-627-1)051697114 | ||
040 | |a DE-627 |b ger |c DE-627 |e rda | ||
041 | |a eng | ||
082 | 0 | |a 005.7565 |2 22 | |
100 | 1 | |a England, Ken |d 1955- |e VerfasserIn |4 aut | |
245 | 1 | 0 | |a Microsoft SQL Server 2005 performance optimization and tuning handbook |c Ken England and Gavin J.T. Powell |
264 | 1 | |a Boston, Mass. ; |a Oxford |b Digital |c 2007 | |
300 | |a 1 Online-Ressource (xvi, 499 Seiten) |b illustrations | ||
336 | |a Text |b txt |2 rdacontent | ||
337 | |a Computermedien |b c |2 rdamedia | ||
338 | |a Online-Ressource |b cr |2 rdacarrier | ||
500 | |a Print version record | ||
520 | |a 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. | ||
630 | 2 | 0 | |a SQL server |
650 | 0 | |a Client/server computing | |
650 | 0 | |a Relational databases | |
650 | 4 | |a SQL server | |
650 | 4 | |a SQL server | |
650 | 4 | |a Architecture client-serveur (Informatique) | |
650 | 4 | |a Bases de données relationnelles | |
650 | 4 | |a Client/server computing | |
650 | 4 | |a Relational databases | |
700 | 1 | |a Powell, Gavin |e MitwirkendeR |4 ctb | |
776 | 1 | |z 9781555583194 | |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781555583194 |
966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781555583194/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
912 | |a ZDB-30-ORH | ||
912 | |a ZDB-30-ORH | ||
951 | |a BO | ||
912 | |a ZDB-30-ORH | ||
049 | |a DE-91 |
Datensatz im Suchindex
DE-BY-TUM_katkey | ZDB-30-ORH-051697114 |
---|---|
_version_ | 1821494841957154816 |
adam_text | |
any_adam_object | |
author | England, Ken 1955- |
author2 | Powell, Gavin |
author2_role | ctb |
author2_variant | g p gp |
author_facet | England, Ken 1955- Powell, Gavin |
author_role | aut |
author_sort | England, Ken 1955- |
author_variant | k e ke |
building | Verbundindex |
bvnumber | localTUM |
collection | ZDB-30-ORH |
ctrlnum | (DE-627-1)051697114 (DE-599)KEP051697114 (ORHE)9781555583194 |
dewey-full | 005.7565 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.7565 |
dewey-search | 005.7565 |
dewey-sort | 15.7565 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02942cam a22005172 4500</leader><controlfield tag="001">ZDB-30-ORH-051697114</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228114133.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">200417s2007 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781555583194</subfield><subfield code="9">978-1-55558-319-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1555583199</subfield><subfield code="9">1-55558-319-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780080554082</subfield><subfield code="9">978-0-08-055408-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0080554083</subfield><subfield code="9">0-08-055408-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)051697114</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP051697114</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781555583194</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)051697114</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">22</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">England, Ken</subfield><subfield code="d">1955-</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft SQL Server 2005 performance optimization and tuning handbook</subfield><subfield code="c">Ken England and Gavin J.T. Powell</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boston, Mass. ;</subfield><subfield code="a">Oxford</subfield><subfield code="b">Digital</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xvi, 499 Seiten)</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">Text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Print version record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">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.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Bases de données relationnelles</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Powell, Gavin</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781555583194</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">9781555583194</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781555583194/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
id | ZDB-30-ORH-051697114 |
illustrated | Illustrated |
indexdate | 2025-01-17T11:20:48Z |
institution | BVB |
isbn | 9781555583194 1555583199 9780080554082 0080554083 |
language | English |
open_access_boolean | |
owner | DE-91 DE-BY-TUM |
owner_facet | DE-91 DE-BY-TUM |
physical | 1 Online-Ressource (xvi, 499 Seiten) illustrations |
psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
publishDate | 2007 |
publishDateSearch | 2007 |
publishDateSort | 2007 |
publisher | Digital |
record_format | marc |
spelling | England, Ken 1955- VerfasserIn aut Microsoft SQL Server 2005 performance optimization and tuning handbook Ken England and Gavin J.T. Powell Boston, Mass. ; Oxford Digital 2007 1 Online-Ressource (xvi, 499 Seiten) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Print version record 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 Architecture client-serveur (Informatique) Bases de données relationnelles Powell, Gavin MitwirkendeR ctb 9781555583194 Erscheint auch als Druck-Ausgabe 9781555583194 |
spellingShingle | England, Ken 1955- Microsoft SQL Server 2005 performance optimization and tuning handbook SQL server Client/server computing Relational databases Architecture client-serveur (Informatique) Bases de données relationnelles |
title | Microsoft SQL Server 2005 performance optimization and tuning handbook |
title_auth | Microsoft SQL Server 2005 performance optimization and tuning handbook |
title_exact_search | Microsoft SQL Server 2005 performance optimization and tuning handbook |
title_full | Microsoft SQL Server 2005 performance optimization and tuning handbook Ken England and Gavin J.T. Powell |
title_fullStr | Microsoft SQL Server 2005 performance optimization and tuning handbook Ken England and Gavin J.T. Powell |
title_full_unstemmed | Microsoft SQL Server 2005 performance optimization and tuning handbook Ken England and Gavin J.T. Powell |
title_short | Microsoft SQL Server 2005 performance optimization and tuning handbook |
title_sort | microsoft sql server 2005 performance optimization and tuning handbook |
topic | SQL server Client/server computing Relational databases Architecture client-serveur (Informatique) Bases de données relationnelles |
topic_facet | SQL server Client/server computing Relational databases Architecture client-serveur (Informatique) Bases de données relationnelles |
work_keys_str_mv | AT englandken microsoftsqlserver2005performanceoptimizationandtuninghandbook AT powellgavin microsoftsqlserver2005performanceoptimizationandtuninghandbook |