Pro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers
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, te...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2020.
|
| Edición: | 1st ed. 2020. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630565806719 |
Tabla de Contenidos:
- 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.
