Learn T-SQL querying: a guide to developing efficient and elegant T-SQL code
Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking...
Gespeichert in:
| Beteiligte Personen: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Birmingham, UK
Packt Publishing Ltd.
2024
|
| Ausgabe: | Second edition. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781837638994/?ar |
| Zusammenfassung: | Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking mastery in modern SQL Server versions and Azure SQL Database. Starting with query processing fundamentals, this book lays a solid foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning how to analyze execution plans for insights into current performance and scalability. Through dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. This book thoroughly covers indexing for T-SQL performance and provides insights into SQL Server's built-in tools for expedited resolution of query performance and scalability issues. Further, hands-on examples will guide you through implementing features such as avoiding UDF pitfalls, understanding predicate SARGability, Query Store, and Query Tuning Assistant. By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and skillfully avoid such pitfalls. |
| Beschreibung: | Includes bibliographical references and index |
| Umfang: | 1 Online-Ressource (456 Seiten) illustrations |
| ISBN: | 9781837638994 |
Internformat
MARC
| LEADER | 00000nam a22000002 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-102206376 | ||
| 003 | DE-627-1 | ||
| 005 | 20240404083422.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240404s2024 xx |||||o 00| ||eng c | ||
| 020 | |a 9781837638994 |9 978-1-83763-899-4 | ||
| 035 | |a (DE-627-1)102206376 | ||
| 035 | |a (DE-599)KEP102206376 | ||
| 035 | |a (ORHE)9781837638994 | ||
| 035 | |a (DE-627-1)102206376 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/85 |2 23/eng/20240305 | |
| 100 | 1 | |a Lopes, Pedro |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Learn T-SQL querying |b a guide to developing efficient and elegant T-SQL code |c Pedro Lopes, Pam Lahoud |
| 250 | |a Second edition. | ||
| 264 | 1 | |a Birmingham, UK |b Packt Publishing Ltd. |c 2024 | |
| 300 | |a 1 Online-Ressource (456 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 Includes bibliographical references and index | ||
| 520 | |a Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking mastery in modern SQL Server versions and Azure SQL Database. Starting with query processing fundamentals, this book lays a solid foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning how to analyze execution plans for insights into current performance and scalability. Through dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. This book thoroughly covers indexing for T-SQL performance and provides insights into SQL Server's built-in tools for expedited resolution of query performance and scalability issues. Further, hands-on examples will guide you through implementing features such as avoiding UDF pitfalls, understanding predicate SARGability, Query Store, and Query Tuning Assistant. By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and skillfully avoid such pitfalls. | ||
| 630 | 2 | 0 | |a SQL server |
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 0 | |a Client/server computing | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a Architecture client-serveur (Informatique) | |
| 700 | 1 | |a Lahoud, Pam |e VerfasserIn |4 aut | |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781837638994/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 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-102206376 |
|---|---|
| _version_ | 1821494934031564800 |
| adam_text | |
| any_adam_object | |
| author | Lopes, Pedro Lahoud, Pam |
| author_facet | Lopes, Pedro Lahoud, Pam |
| author_role | aut aut |
| author_sort | Lopes, Pedro |
| author_variant | p l pl p l pl |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)102206376 (DE-599)KEP102206376 (ORHE)9781837638994 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | Second edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02728nam a22004092 4500</leader><controlfield tag="001">ZDB-30-ORH-102206376</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240404083422.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240404s2024 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781837638994</subfield><subfield code="9">978-1-83763-899-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102206376</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP102206376</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781837638994</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)102206376</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.75/85</subfield><subfield code="2">23/eng/20240305</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lopes, Pedro</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Learn T-SQL querying</subfield><subfield code="b">a guide to developing efficient and elegant T-SQL code</subfield><subfield code="c">Pedro Lopes, Pam Lahoud</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, UK</subfield><subfield code="b">Packt Publishing Ltd.</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (456 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">Includes bibliographical references and index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking mastery in modern SQL Server versions and Azure SQL Database. Starting with query processing fundamentals, this book lays a solid foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning how to analyze execution plans for insights into current performance and scalability. Through dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. This book thoroughly covers indexing for T-SQL performance and provides insights into SQL Server's built-in tools for expedited resolution of query performance and scalability issues. Further, hands-on examples will guide you through implementing features such as avoiding UDF pitfalls, understanding predicate SARGability, Query Store, and Query Tuning Assistant. By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and skillfully avoid such pitfalls.</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">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Lahoud, Pam</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</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/-/9781837638994/?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="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-102206376 |
| illustrated | Illustrated |
| indexdate | 2025-01-17T11:22:15Z |
| institution | BVB |
| isbn | 9781837638994 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (456 Seiten) illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | Packt Publishing Ltd. |
| record_format | marc |
| spelling | Lopes, Pedro VerfasserIn aut Learn T-SQL querying a guide to developing efficient and elegant T-SQL code Pedro Lopes, Pam Lahoud Second edition. Birmingham, UK Packt Publishing Ltd. 2024 1 Online-Ressource (456 Seiten) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes bibliographical references and index Data professionals seeking to excel in Transact-SQL (T-SQL) for Microsoft SQL Server and Azure SQL Database often lack comprehensive resources. This updated second edition of Learn T-SQL Querying focuses on indexing queries and crafting elegant T-SQL code, catering to all data professionals seeking mastery in modern SQL Server versions and Azure SQL Database. Starting with query processing fundamentals, this book lays a solid foundation for writing performant T-SQL queries. You'll explore the mechanics of the Query Optimizer and Query Execution Plans, learning how to analyze execution plans for insights into current performance and scalability. Through dynamic management views (DMVs) and dynamic management functions (DMFs), you'll build diagnostic queries. This book thoroughly covers indexing for T-SQL performance and provides insights into SQL Server's built-in tools for expedited resolution of query performance and scalability issues. Further, hands-on examples will guide you through implementing features such as avoiding UDF pitfalls, understanding predicate SARGability, Query Store, and Query Tuning Assistant. By the end of this book, you'll have developed the ability to identify query performance bottlenecks, recognize anti-patterns, and skillfully avoid such pitfalls. SQL server SQL (Computer program language) Client/server computing SQL (Langage de programmation) Architecture client-serveur (Informatique) Lahoud, Pam VerfasserIn aut |
| spellingShingle | Lopes, Pedro Lahoud, Pam Learn T-SQL querying a guide to developing efficient and elegant T-SQL code SQL server SQL (Computer program language) Client/server computing SQL (Langage de programmation) Architecture client-serveur (Informatique) |
| title | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code |
| title_auth | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code |
| title_exact_search | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code |
| title_full | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code Pedro Lopes, Pam Lahoud |
| title_fullStr | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code Pedro Lopes, Pam Lahoud |
| title_full_unstemmed | Learn T-SQL querying a guide to developing efficient and elegant T-SQL code Pedro Lopes, Pam Lahoud |
| title_short | Learn T-SQL querying |
| title_sort | learn t sql querying a guide to developing efficient and elegant t sql code |
| title_sub | a guide to developing efficient and elegant T-SQL code |
| topic | SQL server SQL (Computer program language) Client/server computing SQL (Langage de programmation) Architecture client-serveur (Informatique) |
| topic_facet | SQL server SQL (Computer program language) Client/server computing SQL (Langage de programmation) Architecture client-serveur (Informatique) |
| work_keys_str_mv | AT lopespedro learntsqlqueryingaguidetodevelopingefficientandeleganttsqlcode AT lahoudpam learntsqlqueryingaguidetodevelopingefficientandeleganttsqlcode |