Muutke küpsiste eelistusi

E-raamat: Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers

3.00/5 (2 hinnangut Goodreads-ist)
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 12-Feb-2020
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484255902
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 49,39 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server DevelopersSuurem pilt
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 12-Feb-2020
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484255902
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Intermediate user level

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
About the Author xi
About the Technical Reviewer xiii
Acknowledgments xv
Introduction xvii
Part I Building Understandable T-SQL
1(120)
Chapter 1 Data Types
3(22)
Number Data Types
3(6)
Exact Number Data Types
3(4)
Approximate Number Data Types
7(1)
Converting Number Data Types
8(1)
String Data Types
9(4)
Character String Data Types
9(2)
Unicode String Data Types
11(1)
Binary String Data Types
12(1)
Date and Time Data Types
13(5)
Date
13(1)
Time
14(1)
Smalldatetime, Datetime, Datetime2, Datetimeoffset
15(3)
Other Data Types
18(7)
Uniqueidentifier
18(1)
XML
18(1)
Spatial Geometry Types
19(1)
Spatial Geography Types
19(1)
SQL_VARIANT
19(2)
Rowversion
21(1)
HIERARCHYID
21(1)
Table
22(1)
Cursor
22(3)
Chapter 2 Database Objects
25(48)
Views
25(7)
User-Defined Views
26(4)
Indexed View
30(2)
Functions
32(14)
Scalar Functions
32(4)
Table-Valued Functions
36(10)
Other User-Defined Objects
46(8)
User-Defined Table Types
46(1)
Table-Valued Parameters
47(3)
Common Table Expressions
50(4)
Temporary Objects
54(7)
Temporary Tables
54(5)
Table Variables
59(2)
Temporary Stored Procedures
61(1)
Triggers
61(5)
Logon Triggers
62(1)
Data Definition Language (DDL) Triggers
62(1)
Data Manipulation Language (DML) Triggers
62(4)
Cursors
66(7)
Forward-Only Cursors
67(2)
Static Cursors
69(1)
Keyset Cursors
70(1)
Dynamic Cursors
70(3)
Chapter 3 Standardizing T-SQL
73(24)
Formatting T-SQL
73(13)
Naming T-SQL
86(5)
Commenting T-SQL
91(6)
Chapter 4 Designing T-SQL
97(24)
Using Stored Procedures
97(5)
Using Parameters
102(9)
Using Complex Logic
111(10)
Part II Building Performant T-SQL
121(98)
Chapter 5 Set-Based Design
123(24)
Introduction to Set-Based Design
123(5)
Thinking in Data Sets
128(8)
Writing Code for Data Sets
136(11)
Chapter 6 Hardware Usage
147(16)
Considering Memory with T-SQL Design
147(6)
Considering Storage with T-SQL Design
153(3)
Considering CPU with T-SQL Design
156(7)
Chapter 7 Execution Plans
163(32)
Reading Execution Plans
163(12)
Index Usage in Execution Plans
175(9)
Logical Join Types in Execution Plans
184(11)
Chapter 8 Optimize T-SQL
195(24)
Optimizing Logical Reads
195(8)
Optimizing Duration
203(4)
Automatic Database Tuning
207(3)
Query Store
208(1)
Automatic Plan Correction
208(2)
Automatic Index Management
210(1)
Intelligent Query Processing
210(9)
Memory Grant Feedback
211(1)
Batch Mode on Rowstore
211(1)
Adaptive Joins
212(7)
Part III Building Manageable T-SQL
219(94)
Chapter 9 Coding Standards
221(22)
Why Use Coding Standards
221(3)
What to Include in Coding Standards
224(19)
T-SQL Design
224(3)
T-SQL Performance
227(10)
T-SQL Usability
237(6)
Chapter 10 Source Control
243(24)
Why Use Source Control
243(4)
How to Use Source Control
247(4)
Setting Up Source Control
251(16)
Chapter 11 Testing
267(22)
Unit Testing
267(13)
Integration Testing
280(5)
Load Testing
285(1)
Static Code Analysis
286(3)
Chapter 12 Deployment
289(24)
Feature Flag
289(7)
Methodology
296(8)
Automated Deployment
304(9)
Part IV Building Maintainable T-SQL
313(86)
Chapter 13 Functional Design
315(30)
Inserting and Updating Data
315(6)
Disable Functionality
321(6)
Support Legacy Code
327(7)
Reporting on Transactional Data
334(6)
Dynamic SQL
340(5)
Chapter 14 Logging
345(16)
Data Modification
345(10)
Error Handling
355(6)
Chapter 15 Managing Data Growth
361(38)
Partitioning
361(8)
Partitioned Tables
369(13)
Partitioned Views
382(7)
Hybrid Workloads
389(10)
Index 399
Elizabeth Noble is a senior database administrator in the metro Atlanta area. It was love at first sight when she was introduced to her first database over 10 years ago. Her passion is to help others improve the quality and speed of deploying database changes through automation. When she is not trying to automate all things, she can be found spending time with her dogs, playing disc golf, or taking a walk at the gym.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842559026e.html