國立高雄大學圖資館 |

Language: English

Back

Pro T-SQL 2019toward speed, scalabil...

Noble, Elizabeth.

Pro T-SQL 2019toward speed, scalability, and standardization for SQL server developers /

Record Type:	Electronic resources : Monograph/item
Title/Author:	Pro T-SQL 2019by Elizabeth Noble.
Reminder of title:	toward speed, scalability, and standardization for SQL server developers /
Author:	Noble, Elizabeth.
Published:	Berkeley, CA :Apress :2020.
Description:	xvii, 406 p. :ill., digital ;24 cm.
Contained By:	Springer eBooks
Subject:	SQL (Computer program language)
Online resource:	https://doi.org/10.1007/978-1-4842-5590-2
ISBN:	9781484255902$q(electronic bk.)

Pro T-SQL 2019toward 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. - Berkeley, CA :Apress :2020. - xvii, 406 p. :ill., digital ;24 cm.

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$q(electronic bk.)

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

189402
SQL (Computer program language)

LC Class. No.: QA76.73.S67 / N635 2020

Dewey Class. No.: 005.756

Pro T-SQL 2019toward speed, scalability, and standardization for SQL server developers /
LDR:02684nmm a2200337 a 4500 001 575271
003 DE-He213
005 20200212185527.0
006 m d
007 cr nn 008maaau
008 201016s2020 cau s 0 eng d
020 $a 9781484255902$q(electronic bk.)
020 $a 9781484255896$q(paper)
024 7 $a 10.1007/978-1-4842-5590-2 $2 doi
035 $a 978-1-4842-5590-2
040 $a GP $c GP
041 0 $a eng
050 4 $a QA76.73.S67 $b N635 2020
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.756 $2 23
090 $a QA76.73.S67 $b N748 2020
100 1 $a Noble, Elizabeth. $3 863150
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.
260 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a xvii, 406 p. : $b ill., digital ; $c 24 cm.
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 SQL (Computer program language) $3 189402
650 1 4 $a Database Management. $3 273994
650 2 4 $a Microsoft and .NET. $3 760507
710 2 $a SpringerLink (Online service) $3 273601
773 0 $t Springer eBooks
856 4 0 $u https://doi.org/10.1007/978-1-4842-5590-2
950 $a Professional and Applied Computing (Springer-12059)