Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Autor Corporativo: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
[United States] :
Apress,
2020.
|
| Edición: | 1st edition. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_on1143014567 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||||||| | ||
| 008 | 160220s2020 xxu o 001 0 eng | ||
| 040 | |a AU@ |b eng |e pn |c AU@ |d GW5XE |d TEFOD |d EBLCP |d OCLCQ |d UKMGB |d LQU |d SFB |d UPM |d OCLCF |d SRU |d UKAHL |d OCLCQ |d OCLCO |d GUA |d OCLCQ |d VT2 |d UKBTH |d OCLCO | ||
| 015 | |a GBC042089 |2 bnb | ||
| 016 | 7 | |a 019720454 |2 Uk | |
| 019 | |a 1140788341 |a 1142400903 |a 1153154671 |a 1153943671 |a 1154485118 |a 1155225843 | ||
| 020 | |a 9781484255902 |q (electronic bk.) | ||
| 020 | |a 1484255909 |q (electronic bk.) | ||
| 020 | |z 9781484255896 | ||
| 024 | 8 | |a 9781484255896 | |
| 024 | 8 | |a 9781484255902 | |
| 024 | 8 | |a 10.1007/978-1-4842-5 | |
| 029 | 0 | |a AU@ |b 000066784400 | |
| 029 | 1 | |a UKMGB |b 019720454 | |
| 035 | |a (OCoLC)1143014567 |z (OCoLC)1140788341 |z (OCoLC)1142400903 |z (OCoLC)1153154671 |z (OCoLC)1153943671 |z (OCoLC)1154485118 |z (OCoLC)1155225843 | ||
| 037 | |a 47CE7229-CACF-49E9-8B54-B7ADFC6AD3B9 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a QA76.73.C67 | |
| 082 | 0 | 4 | |a 005.75/6 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Noble, Elizabeth |c (Database administrator), |e author. | |
| 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 resource (xvii, 406 pages) | ||
| 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 | ||
| 504 | |a Includes index. | ||
| 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. | ||
| 542 | |f © Copyright 2020 Elizabeth Noble. |g 2020 | ||
| 550 | |a Made available through: Safari, an O'Reilly Media Company. | ||
| 588 | |a Online resource; Title from title page (viewed February 12, 2020) | ||
| 505 | 0 | |a Intro -- Table of Contents -- About the Author -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Part I: Building Understandable T-SQL -- Chapter 1: Data Types -- Number Data Types -- Exact Number Data Types -- BIT -- TINYINT, SMALLINT, INT, BIGINT -- DECIMAL/NUMERIC -- SMALLMONEY, MONEY -- Approximate Number Data Types -- Converting Number Data Types -- String Data Types -- Character String Data Types -- CHAR and VARCHAR -- TEXT -- Unicode String Data Types -- NCHAR and NVARCHAR -- NTEXT -- Binary String Data Types -- BINARY and VARBINARY -- IMAGE | |
| 505 | 8 | |a Date and Time Data Types -- DATE -- TIME -- SMALLDATETIME, DATETIME, DATETIME2, DATETIMEOFFSET -- Other Data Types -- UNIQUEIDENTIFIER -- XML -- Spatial Geometry Types -- Spatial Geography Types -- SQL_VARIANT -- Rowversion -- HIERARCHYID -- Table -- Cursor -- Chapter 2: Database Objects -- Views -- User-Defined Views -- Indexed View -- Functions -- Scalar Functions -- Table-Valued Functions -- Inline Table-Valued Functions -- Multi-statement Table-Valued Functions -- Other User-Defined Objects -- User-Defined Table Types -- Table-Valued Parameters -- Common Table Expressions -- Temporary Objects | |
| 505 | 8 | |a Temporary Tables -- Local Temporary Tables -- Global Temporary Tables -- Persistent Temporary Table -- Table Variables -- Temporary Stored Procedures -- Triggers -- Logon Triggers -- Data Definition Language (DDL) Triggers -- Data Manipulation Language (DML) Triggers -- Cursors -- Forward-Only Cursors -- Static Cursors -- Keyset Cursors -- Dynamic Cursors -- Chapter 3: Standardizing T-SQL -- Formatting T-SQL -- Naming T-SQL -- Commenting T-SQL -- Chapter 4: Designing T-SQL -- Using Stored Procedures -- Using Parameters -- Using Complex Logic -- Part II: Building Performant T-SQL | |
| 505 | 8 | |a Chapter 5: Set-Based Design -- Introduction to Set-Based Design -- Thinking in Data Sets -- Writing Code for Data Sets -- Chapter 6: Hardware Usage -- Considering Memory with T-SQL Design -- Considering Storage with T-SQL Design -- Considering CPU with T-SQL Design -- Chapter 7: Execution Plans -- Reading Execution Plans -- Index Usage in Execution Plans -- Logical Join Types in Execution Plans -- Chapter 8: Optimize T-SQL -- Optimizing Logical Reads -- Optimizing Duration -- Automatic Database Tuning -- Query Store -- Automatic Plan Correction -- Automatic Index Management | |
| 505 | 8 | |a Intelligent Query Processing -- Memory Grant Feedback -- Batch Mode on Rowstore -- Adaptive Joins -- Part III: Building Manageable T-SQL -- Chapter 9: Coding Standards -- Why Use Coding Standards -- What to Include in Coding Standards -- T-SQL Design -- ANSI STANDARD -- Normal Form -- Table Size -- Name Value Pair -- Primary Key -- Foreign Key -- Non-clustered Index -- Constraint Definition -- T-SQL Performance -- Select Necessary Data -- Sargeable -- Implicit Conversion -- SET NOCOUNT ON -- NULL Values -- NOLOCK -- RECOMPILE -- T-SQL Usability -- Linked Server -- Column Definition -- BETWEEN | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 650 | 0 | |a SQL (Computer program language) | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 710 | 2 | |a Safari, an O'Reilly Media Company. | |
| 776 | 0 | 8 | |i Print version: |a Noble, Elizabeth. |t Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers. |d Berkeley, CA : Apress L.P., ©2020 |z 9781484255896 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781484255902/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH37357043 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL6109042 | ||
| 994 | |a 92 |b IZTAP | ||