國立虎尾科技大學 |

Pro T-SQL 2019 = Toward Speed, Scalability, and Standardization for SQL Server Developers /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Pro T-SQL 2019/ by Elizabeth Noble.
Reminder of title:	Toward Speed, Scalability, and Standardization for SQL Server Developers /
Author:	Noble, Elizabeth.
Description:	XVII, 406 p. 138 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Database management. -
Online resource:	https://doi.org/10.1007/978-1-4842-5590-2
ISBN:	9781484255902

Pro T-SQL 2019 = Toward Speed, Scalability, and Standardization for SQL Server Developers /
Noble, Elizabeth.

Pro T-SQL 2019Toward Speed, Scalability, and Standardization for SQL Server Developers /[electronic resource] :by Elizabeth Noble. - 1st ed. 2020. - XVII, 406 p. 138 illus.online resource.

Introduction -- Part I. Building Understandable T-SQL -- 1. Data Types -- 2. Database Objects -- 3. Standardizing T-SQL -- 4. Designing T-SQL -- Part II. Building Performant T-SQL -- 5. Set-Based Design -- 6. Hardware Usage -- 7. Execution Plans -- 8. Optimize T-SQL -- Part III. Building Manageable T-SQL -- 9. Coding Standards -- 10. Source Control -- 11. Testing -- 12. Deployment -- Part IV. Building Maintainable T-SQL -- 13. Functional Design -- 14. Logging -- 15. Managing Data Growth.

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. You will: 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.

ISBN: 9781484255902

Standard No.: 10.1007/978-1-4842-5590-2doiSubjects--Topical Terms:

557799
Database management.

LC Class. No.: QA76.9.D3

Dewey Class. No.: 005.74

Pro T-SQL 2019 = Toward Speed, Scalability, and Standardization for SQL Server Developers /
LDR:02979nam a22003975i 4500 001 1023737
003 DE-He213
005 20200702013255.0
007 cr nn 008mamaa
008 210318s2020 xxu| s |||| 0|eng d
020 $a 9781484255902 $9 978-1-4842-5590-2
024 7 $a 10.1007/978-1-4842-5590-2 $2 doi
035 $a 978-1-4842-5590-2
050 4 $a QA76.9.D3
072 7 $a UN $2 bicssc
072 7 $a COM021000 $2 bisacsh
072 7 $a UN $2 thema
072 7 $a UMT $2 thema
082 0 4 $a 005.74 $2 23
100 1 $a Noble, Elizabeth. $e author. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1319753
245 1 0 $a Pro T-SQL 2019 $h [electronic resource] : $b Toward Speed, Scalability, and Standardization for SQL Server Developers / $c by Elizabeth Noble.
250 $a 1st ed. 2020.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a XVII, 406 p. 138 illus. $b online resource.
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 $b PDF $2 rda
505 0 $a Introduction -- Part I. Building Understandable T-SQL -- 1. Data Types -- 2. Database Objects -- 3. Standardizing T-SQL -- 4. Designing T-SQL -- Part II. Building Performant T-SQL -- 5. Set-Based Design -- 6. Hardware Usage -- 7. Execution Plans -- 8. Optimize T-SQL -- Part III. Building Manageable T-SQL -- 9. Coding Standards -- 10. Source Control -- 11. Testing -- 12. Deployment -- Part IV. Building Maintainable T-SQL -- 13. Functional Design -- 14. Logging -- 15. Managing Data Growth.
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. You will: 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.
650 0 $a Database management. $3 557799
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 1 4 $a Database Management. $3 669820
650 2 4 $a Microsoft and .NET. $3 1114109
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484255896
776 0 8 $i Printed edition: $z 9781484255919
856 4 0 $u https://doi.org/10.1007/978-1-4842-5590-2
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)