Cargando…

Expert Performance Indexing in SQL Server

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,...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autores principales: Strate, Jason (Autor), Fritchey, Grant (Autor)
Autor Corporativo: SpringerLink (Online service)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Berkeley, CA : Apress : Imprint: Apress, 2015.
Edición:2nd ed. 2015.
Temas:
Acceso en línea:Texto Completo

MARC

LEADER 00000nam a22000005i 4500
001 978-1-4842-1118-2
003 DE-He213
005 20220124155948.0
007 cr nn 008mamaa
008 151111s2015 xxu| s |||| 0|eng d
020 |a 9781484211182  |9 978-1-4842-1118-2 
024 7 |a 10.1007/978-1-4842-1118-2  |2 doi 
050 4 |a QA76.9.D3 
072 7 |a UN  |2 bicssc 
072 7 |a COM021000  |2 bisacsh 
072 7 |a UN  |2 thema 
082 0 4 |a 005.74  |2 23 
100 1 |a Strate, Jason.  |e author.  |4 aut  |4 http://id.loc.gov/vocabulary/relators/aut 
245 1 0 |a Expert Performance Indexing in SQL Server  |h [electronic resource] /  |c by Jason Strate, Grant Fritchey. 
250 |a 2nd ed. 2015. 
264 1 |a Berkeley, CA :  |b Apress :  |b Imprint: Apress,  |c 2015. 
300 |a XXIII, 403 p. 238 illus.  |b online resource. 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |b PDF  |2 rda 
520 |a 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. 
650 0 |a Database management. 
650 1 4 |a Database Management. 
700 1 |a Fritchey, Grant.  |e author.  |4 aut  |4 http://id.loc.gov/vocabulary/relators/aut 
710 2 |a SpringerLink (Online service) 
773 0 |t Springer Nature eBook 
776 0 8 |i Printed edition:  |z 9781484211199 
776 0 8 |i Printed edition:  |z 9781484211205 
856 4 0 |u https://doi.uam.elogim.com/10.1007/978-1-4842-1118-2  |z Texto Completo 
912 |a ZDB-2-CWD 
912 |a ZDB-2-SXPC 
950 |a Professional and Applied Computing (SpringerNature-12059) 
950 |a Professional and Applied Computing (R0) (SpringerNature-43716)