Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers / / by Elizabeth Noble
(Visualizza in formato marc)
(Visualizza in BIBFRAME)
| Autore: |
Noble Elizabeth
|
| Titolo: |
Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers / / by Elizabeth Noble
|
| Pubblicazione: | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020 |
| Edizione: | 1st ed. 2020. |
| Descrizione fisica: | 1 online resource (XVII, 406 p. 138 illus.) |
| Disciplina: | 005.756 |
| Soggetto topico: | Database management |
| Microsoft software | |
| Microsoft .NET Framework | |
| Database Management | |
| Microsoft and .NET | |
| Note generali: | Includes index. |
| Nota di contenuto: | 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. |
| Sommario/riassunto: | 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. |
| Titolo autorizzato: | Pro T-SQL 2019 |
| ISBN: | 9781484255902 |
| 1484255909 | |
| Formato: | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione: | Inglese |
| Record Nr.: | 9910380734903321 |
| Lo trovi qui: | Univ. Federico II |
| Opac: | Controlla la disponibilità qui |