Cargando…
Microsoft SQL server 2014 query tuning & optimization /
This book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. Topics include: understanding how the query optimizer works; troubleshooting queries using extende...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill Education,
[2015]
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | OR_ocn904597713 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150310s2015 nyua ob 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d STF |d B24X7 |d TEFOD |d COO |d DEBBG |d OCLCF |d OCLCQ |d TEFOD |d TOH |d C6I |d VT2 |d YDX |d INARC |d OCLCO |d OCL |d OCLCQ |d OCLCO | ||
| 015 | |a GBB4C5495 |2 bnb | ||
| 016 | 7 | |a 016938603 |2 Uk | |
| 019 | |a 907368992 |a 910550431 |a 1103273591 | ||
| 020 | |a 9780071829434 |q (electronic bk.) | ||
| 020 | |a 0071829431 |q (electronic bk.) | ||
| 020 | |z 9780071829427 | ||
| 020 | |z 0071829423 | ||
| 029 | 1 | |a AU@ |b 000057234116 | |
| 029 | 1 | |a AU@ |b 000062476496 | |
| 029 | 1 | |a DEBBG |b BV042682762 | |
| 029 | 1 | |a DEBSZ |b 446579637 | |
| 035 | |a (OCoLC)904597713 |z (OCoLC)907368992 |z (OCoLC)910550431 |z (OCoLC)1103273591 | ||
| 037 | |a CL0500000566 |b Safari Books Online | ||
| 037 | |a 93446FA6-92BC-4AF6-A8D5-F66B2D02993E |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.9.C55 | |
| 082 | 0 | 4 | |a 005.75/85 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Nevarez, Benjamin, |e author. | |
| 245 | 1 | 0 | |a Microsoft SQL server 2014 query tuning & optimization / |c Benjamin Nevarez. |
| 246 | 3 | 0 | |a Query tuning and optimization |
| 264 | 1 | |a New York : |b McGraw-Hill Education, |c [2015] | |
| 264 | 4 | |c ©2015 | |
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 504 | |a Includes bibliographical references and index. | ||
| 520 | |a This book describes the inner workings of the query processor so you can write better queries and provide the query processor with the quality information it needs to produce efficient execution plans. Topics include: understanding how the query optimizer works; troubleshooting queries using extended events, SQL trace, dynamic management views (DMVs), the data collector, and other tools; working with query operators for data access, joins, aggregations, parallelism, and updates; speeding up queries and improving application performance; understanding statistics and how to detect and fix cardinality estimation errors; maximizing OLTP query performance using In-Memory OLTP (Hekaton) features, including memory-optimized tables and natively compiled stored procedures; monitoring and promoting plan caching and reuse; improving the performance of data warehouse queries; and handling query processor limitations with hints and other methods. -- |c Edited summary from book. | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a Querying (Computer science) | |
| 650 | 0 | |a Database management. | |
| 650 | 0 | |a Relational databases. | |
| 650 | 0 | |a Client/server computing. | |
| 650 | 0 | |a Database searching. | |
| 650 | 6 | |a Bases de données |x Interrogation. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a online searching. |2 aat | |
| 650 | 7 | |a Database searching |2 fast | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Querying (Computer science) |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 776 | 0 | 8 | |i Print version: |a Nevarez, Benjamin. |t Microsoft SQL server 2014 query tuning & optimization. |d New York : Mcgraw-Hill Education, [2015] |z 0071829423 |w (OCoLC)864700500 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780071829427/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Books 24x7 |b B247 |n bks00077177 | ||
| 938 | |a Internet Archive |b INAR |n microsoftsqlserv0000neva_p5q3 | ||
| 938 | |a YBP Library Services |b YANK |n 16841051 | ||
| 994 | |a 92 |b IZTAP | ||