Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, te...
Saved in:
| Main Author: | |
|---|---|
| Corporate Author: | |
| Format: | Electronic eBook |
| Language: | English |
| Published: |
[United States]
Apress
2020
|
| Edition: | 1st edition. |
| Subjects: | |
| Links: | https://learning.oreilly.com/library/view/-/9781484255902/?ar |
| Summary: | Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. What You Will Learn Choose correct data types and database objects when designing T-SQL Write T-SQL that searches data efficiently and uses hardware effectively Implement source control and testing methods to streamline the deployment process Design T-SQL that can be enhanced or modified with less effort Plan for long-term data management and storage Who This Book Is For Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain. |
| Item Description: | Includes index. - Online resource; Title from title page (viewed February 12, 2020) |
| Physical Description: | 1 Online-Ressource (xvii, 406 Seiten) |
| ISBN: | 9781484255902 1484255909 |
Staff View
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-050006657 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228121005.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 200227s2020 xx |||||o 00| ||eng c | ||
| 020 | |a 9781484255902 |c electronic bk. |9 978-1-4842-5590-2 | ||
| 020 | |a 1484255909 |c electronic bk. |9 1-4842-5590-9 | ||
| 035 | |a (DE-627-1)050006657 | ||
| 035 | |a (DE-599)KEP050006657 | ||
| 035 | |a (ORHE)9781484255902 | ||
| 035 | |a (DE-627-1)050006657 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.75/6 |2 23 | |
| 100 | 1 | |a Noble, Elizabeth |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Pro T-SQL 2019 |b Toward Speed, Scalability, and Standardization for SQL Server Developers |c Noble, Elizabeth |
| 250 | |a 1st edition. | ||
| 264 | 1 | |a [United States] |b Apress |c 2020 | |
| 300 | |a 1 Online-Ressource (xvii, 406 Seiten) | ||
| 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 index. - Online resource; Title from title page (viewed February 12, 2020) | ||
| 520 | |a Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. What You Will Learn Choose correct data types and database objects when designing T-SQL Write T-SQL that searches data efficiently and uses hardware effectively Implement source control and testing methods to streamline the deployment process Design T-SQL that can be enhanced or modified with less effort Plan for long-term data management and storage Who This Book Is For Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain. | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 4 | |a SQL (Langage de programmation) | |
| 650 | 4 | |a SQL (Computer program language) | |
| 710 | 2 | |a Safari, an O'Reilly Media Company. |e MitwirkendeR |4 ctb | |
| 776 | 1 | |z 9781484255896 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 9781484255896 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781484255902/?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 | ||
Record in the Search Index
| DE-BY-TUM_katkey | ZDB-30-ORH-050006657 |
|---|---|
| _version_ | 1829007756467634176 |
| adam_text | |
| any_adam_object | |
| author | Noble, Elizabeth |
| author_corporate | Safari, an O'Reilly Media Company |
| author_corporate_role | ctb |
| author_facet | Noble, Elizabeth Safari, an O'Reilly Media Company |
| author_role | aut |
| author_sort | Noble, Elizabeth |
| author_variant | e n en |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)050006657 (DE-599)KEP050006657 (ORHE)9781484255902 |
| dewey-full | 005.75/6 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/6 |
| dewey-search | 005.75/6 |
| dewey-sort | 15.75 16 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1st edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03029cam a22004332c 4500</leader><controlfield tag="001">ZDB-30-ORH-050006657</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228121005.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">200227s2020 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781484255902</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">978-1-4842-5590-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1484255909</subfield><subfield code="c">electronic bk.</subfield><subfield code="9">1-4842-5590-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)050006657</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP050006657</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781484255902</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)050006657</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/6</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Noble, Elizabeth</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Pro T-SQL 2019</subfield><subfield code="b">Toward Speed, Scalability, and Standardization for SQL Server Developers</subfield><subfield code="c">Noble, Elizabeth</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[United States]</subfield><subfield code="b">Apress</subfield><subfield code="c">2020</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xvii, 406 Seiten)</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 index. - Online resource; Title from title page (viewed February 12, 2020)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. What You Will Learn Choose correct data types and database objects when designing T-SQL Write T-SQL that searches data efficiently and uses hardware effectively Implement source control and testing methods to streamline the deployment process Design T-SQL that can be enhanced or modified with less effort Plan for long-term data management and storage Who This Book Is For Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</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">SQL (Computer program language)</subfield></datafield><datafield tag="710" ind1="2" ind2=" "><subfield code="a">Safari, an O'Reilly Media Company.</subfield><subfield code="e">MitwirkendeR</subfield><subfield code="4">ctb</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">9781484255896</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">9781484255896</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/-/9781484255902/?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-050006657 |
| illustrated | Not Illustrated |
| indexdate | 2025-04-10T09:35:21Z |
| institution | BVB |
| isbn | 9781484255902 1484255909 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (xvii, 406 Seiten) |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2020 |
| publishDateSearch | 2020 |
| publishDateSort | 2020 |
| publisher | Apress |
| record_format | marc |
| spelling | Noble, Elizabeth VerfasserIn aut Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers Noble, Elizabeth 1st edition. [United States] Apress 2020 1 Online-Ressource (xvii, 406 Seiten) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes index. - Online resource; Title from title page (viewed February 12, 2020) Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward explanations. Attention is given to selecting the right data types and objects when designing T-SQL solutions. Author Elizabeth Noble teaches you how to improve your T-SQL performance through good design practices that benefit programmers and ultimately the users of the applications. You will know the common pitfalls of writing T-SQL and how to avoid those pitfalls going forward. What You Will Learn Choose correct data types and database objects when designing T-SQL Write T-SQL that searches data efficiently and uses hardware effectively Implement source control and testing methods to streamline the deployment process Design T-SQL that can be enhanced or modified with less effort Plan for long-term data management and storage Who This Book Is For Database developers who want to improve the efficiency of their applications, and developers who want to solve complex query and data problems more easily by writing T-SQL that performs well, brings back correct results, and is easy for other developers to understand and maintain. SQL (Computer program language) SQL (Langage de programmation) Safari, an O'Reilly Media Company. MitwirkendeR ctb 9781484255896 Erscheint auch als Druck-Ausgabe 9781484255896 |
| spellingShingle | Noble, Elizabeth Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers SQL (Computer program language) SQL (Langage de programmation) |
| title | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers |
| title_auth | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers |
| title_exact_search | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers |
| title_full | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers Noble, Elizabeth |
| title_fullStr | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers Noble, Elizabeth |
| title_full_unstemmed | Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers Noble, Elizabeth |
| title_short | Pro T-SQL 2019 |
| title_sort | pro t sql 2019 toward speed scalability and standardization for sql server developers |
| title_sub | Toward Speed, Scalability, and Standardization for SQL Server Developers |
| topic | SQL (Computer program language) SQL (Langage de programmation) |
| topic_facet | SQL (Computer program language) SQL (Langage de programmation) |
| work_keys_str_mv | AT nobleelizabeth protsql2019towardspeedscalabilityandstandardizationforsqlserverdevelopers AT safarianoreillymediacompany protsql2019towardspeedscalabilityandstandardizationforsqlserverdevelopers |