Saved in:
| Title: | Expert Performance Indexing in SQL Server |
|---|---|
| From: |
by Jason Strate, Grant Fritchey
|
| Person: |
Strate, Jason
Verfasser aut Fritchey, Grant |
| Main Authors: | , |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2015
|
| Edition: | 2nd ed. |
| Subjects: | |
| Online Access: | https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 https://doi.org/10.1007/978-1-4842-1118-2 http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028632050&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| Physical Description: | 1 Online-Ressource (XXIII, 403 p. 238 illus) |
| ISBN: | 9781484211182 |
| DOI: | 10.1007/978-1-4842-1118-2 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043208889 | ||
| 003 | DE-604 | ||
| 005 | 20160721 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 151215s2015 xx o|||| 00||| eng d | ||
| 020 | |a 9781484211182 |c Online |9 978-1-4842-1118-2 | ||
| 024 | 7 | |a 10.1007/978-1-4842-1118-2 |2 doi | |
| 035 | |a (OCoLC)932035559 | ||
| 035 | |a (DE-599)BVBBV043208889 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-863 |a DE-898 |a DE-862 |a DE-92 |a DE-M347 |a DE-1049 | ||
| 082 | 0 | |a 004 | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 100 | 1 | |a Strate, Jason |e Verfasser |0 (DE-588)1027403093 |4 aut | |
| 245 | 1 | 0 | |a Expert Performance Indexing in SQL Server |c by Jason Strate, Grant Fritchey |
| 250 | |a 2nd ed. | ||
| 264 | 1 | |a Berkeley, CA |b Apress |c 2015 | |
| 300 | |a 1 Online-Ressource (XXIII, 403 p. 238 illus) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 650 | 0 | 7 | |a SQL Server |0 (DE-588)4343204-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Informatik |0 (DE-588)4026894-9 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Informatik |0 (DE-588)4026894-9 |D s |
| 689 | 0 | 1 | |a Datenbankverwaltung |0 (DE-588)4389357-0 |D s |
| 689 | 0 | 2 | |a SQL Server |0 (DE-588)4343204-9 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Fritchey, Grant |e Verfasser |0 (DE-588)1084025159 |4 aut | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druckausgabe |z 978-1-4842-1119-9 |
| 856 | 4 | 0 | |u https://doi.org/10.1007/978-1-4842-1118-2 |x Verlag |3 Volltext |
| 856 | 4 | 2 | |m Springer Fremddatenuebernahme |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028632050&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Abstract |
| 912 | |a ZDB-2-CWD | ||
| 940 | 1 | |q ZDB-2-CWD_2015 | |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-028632050 | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-M347 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-92 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-898 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-1049 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-863 |p ZDB-2-CWD |x Verlag |3 Volltext | |
| 966 | e | |u https://doi.org/10.1007/978-1-4842-1118-2 |l DE-862 |p ZDB-2-CWD |x Verlag |3 Volltext | |
Record in the Search Index
| DE-BY-OTHR_katkey | 5709396 |
|---|---|
| _version_ | 1831257048495423488 |
| adam_text | EXPERT PERFORMANCE INDEXING IN SQL SERVER
/ STRATE, JASON
: 2015
ABSTRACT / INHALTSTEXT
THIS BOOK IS A DEEP DIVE INTO PERHAPS THE SINGLE-MOST IMPORTANT FACET OF
GOOD PERFORMANCE: INDEXES, AND HOW TO BEST USE THEM. THE BOOK BEGINS IN
THE SHALLOW WATERS WITH EXPLANATIONS OF THE TYPES OF INDEXES AND HOW
THEY ARE STORED IN DATABASES. MOVING DEEPER INTO THE TOPIC, AND FURTHER
INTO THE BOOK, YOU WILL LOOK AT THE STATISTICS THAT ARE ACCUMULATED BOTH
BY INDEXES AND ON INDEXES. YOU’LL BETTER UNDERSTAND WHAT INDEXES ARE
DOING IN THE DATABASE AND WHAT CAN BE DONE TO MITIGATE AND IMPROVE THEIR
EFFECT ON PERFORMANCE. THE FINAL DESTINATION IS A GUIDED TOUR THROUGH A
NUMBER OF REAL LIFE SCENARIOS SHOWING APPROACHES YOU CAN TAKE TO
INVESTIGATE, MITIGATE, AND IMPROVE THE PERFORMANCE OF YOUR DATABASE.
DEFINES THE TYPES OF INDEXES AND THEIR IMPLEMENTATION OPTIONS PROVIDES
USE CASES AND COMMON PATTERNS IN APPLYING INDEXING DESCRIBES AND EXPLAIN
THE INDEX METADATA AND STATISTICS PROVIDES A FRAMEWORK OF STRATEGIES AND
APPROACHES FOR INDEXING DATABASES
DIESES SCHRIFTSTUECK WURDE MASCHINELL ERZEUGT.
|
| any_adam_object | 1 |
| author | Strate, Jason Fritchey, Grant |
| author_GND | (DE-588)1027403093 (DE-588)1084025159 |
| author_facet | Strate, Jason Fritchey, Grant |
| author_role | aut aut |
| author_sort | Strate, Jason |
| author_variant | j s js g f gf |
| building | Verbundindex |
| bvnumber | BV043208889 |
| classification_rvk | ST 271 |
| collection | ZDB-2-CWD |
| ctrlnum | (OCoLC)932035559 (DE-599)BVBBV043208889 |
| dewey-full | 004 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004 |
| dewey-search | 004 |
| dewey-sort | 14 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| doi_str_mv | 10.1007/978-1-4842-1118-2 |
| edition | 2nd ed. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02423nam a2200529zc 4500</leader><controlfield tag="001">BV043208889</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160721 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">151215s2015 xx o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484211182</subfield><subfield code="c">Online</subfield><subfield code="9">978-1-4842-1118-2</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1007/978-1-4842-1118-2</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)932035559</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043208889</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield><subfield code="a">DE-898</subfield><subfield code="a">DE-862</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-M347</subfield><subfield code="a">DE-1049</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">004</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Strate, Jason</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1027403093</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Expert Performance Indexing in SQL Server</subfield><subfield code="c">by Jason Strate, Grant Fritchey</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berkeley, CA</subfield><subfield code="b">Apress</subfield><subfield code="c">2015</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (XXIII, 403 p. 238 illus)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Informatik</subfield><subfield code="0">(DE-588)4026894-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbankverwaltung</subfield><subfield code="0">(DE-588)4389357-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">SQL Server</subfield><subfield code="0">(DE-588)4343204-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Fritchey, Grant</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1084025159</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druckausgabe</subfield><subfield code="z">978-1-4842-1119-9</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Springer Fremddatenuebernahme</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028632050&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Abstract</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-2-CWD</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">ZDB-2-CWD_2015</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028632050</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-M347</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-92</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-898</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-1049</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-863</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://doi.org/10.1007/978-1-4842-1118-2</subfield><subfield code="l">DE-862</subfield><subfield code="p">ZDB-2-CWD</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043208889 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-20T17:31:11Z |
| institution | BVB |
| isbn | 9781484211182 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028632050 |
| oclc_num | 932035559 |
| open_access_boolean | |
| owner | DE-863 DE-BY-FWS DE-898 DE-BY-UBR DE-862 DE-BY-FWS DE-92 DE-M347 DE-1049 |
| owner_facet | DE-863 DE-BY-FWS DE-898 DE-BY-UBR DE-862 DE-BY-FWS DE-92 DE-M347 DE-1049 |
| physical | 1 Online-Ressource (XXIII, 403 p. 238 illus) |
| psigel | ZDB-2-CWD ZDB-2-CWD_2015 |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Apress |
| record_format | marc |
| spellingShingle | Strate, Jason Fritchey, Grant Expert Performance Indexing in SQL Server SQL Server (DE-588)4343204-9 gnd Informatik (DE-588)4026894-9 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| subject_GND | (DE-588)4343204-9 (DE-588)4026894-9 (DE-588)4389357-0 |
| title | Expert Performance Indexing in SQL Server |
| title_auth | Expert Performance Indexing in SQL Server |
| title_exact_search | Expert Performance Indexing in SQL Server |
| title_full | Expert Performance Indexing in SQL Server by Jason Strate, Grant Fritchey |
| title_fullStr | Expert Performance Indexing in SQL Server by Jason Strate, Grant Fritchey |
| title_full_unstemmed | Expert Performance Indexing in SQL Server by Jason Strate, Grant Fritchey |
| title_short | Expert Performance Indexing in SQL Server |
| title_sort | expert performance indexing in sql server |
| topic | SQL Server (DE-588)4343204-9 gnd Informatik (DE-588)4026894-9 gnd Datenbankverwaltung (DE-588)4389357-0 gnd |
| topic_facet | SQL Server Informatik Datenbankverwaltung |
| url | https://doi.org/10.1007/978-1-4842-1118-2 http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028632050&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT stratejason expertperformanceindexinginsqlserver AT fritcheygrant expertperformanceindexinginsqlserver |