語系:
繁體中文
English
說明(常見問題)
登入
回首頁
切換:
標籤
|
MARC模式
|
ISBD
Pro T-SQL 2019 = Toward Speed, Scala...
~
Noble, Elizabeth.
Pro T-SQL 2019 = Toward Speed, Scalability, and Standardization for SQL Server Developers /
紀錄類型:
書目-語言資料,印刷品 : Monograph/item
正題名/作者:
Pro T-SQL 2019/ by Elizabeth Noble.
其他題名:
Toward Speed, Scalability, and Standardization for SQL Server Developers /
作者:
Noble, Elizabeth.
面頁冊數:
XVII, 406 p. 138 illus.online resource. :
Contained By:
Springer Nature eBook
標題:
Microsoft and .NET. -
電子資源:
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 2019
Toward 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:
1114109
Microsoft and .NET.
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
2 4
$a
Microsoft and .NET.
$3
1114109
650
1 4
$a
Database Management.
$3
669820
650
0
$a
Microsoft .NET Framework.
$3
565417
650
0
$a
Microsoft software.
$3
1253736
650
0
$a
Database management.
$3
557799
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)
筆 0 讀者評論
多媒體
評論
新增評論
分享你的心得
Export
取書館別
處理中
...
變更密碼[密碼必須為2種組合(英文和數字)及長度為10碼以上]
登入