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


Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
By 作者:Elizabeth Noble
pages 页数: 406 pages
Publisher Finelybook 出版社: Apress; 1st ed. edition (February 13, 2020)
Language 语言: English
ISBN-10 书号:1484255895
ISBN-13 书号:9781484255896
The Book Description robot was collected from Amazon and arranged by Finelybook

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


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

下载地址 DOWNLOAD隐藏内容需1积分,请先!没有帐号? 注 册 一个!
觉得文章有用就打赏一下文章作者
未经允许不得转载:finelybook » Pro T-SQL 2019: Toward Speed, Scalability, and Standardization for SQL Server Developers
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏