Pro T-SQL 2019 : Toward Speed, Scalability, and Standardization for SQL Server Developers / / by Elizabeth Noble

• Record Nr.: UNINA9910380734903321
• Autore: Noble Elizabeth
• Pubbl/distr/stampa: Berkeley, CA : , : Apress : , : Imprint : Apress, , 2020
• ISBN: 9781484255902; 1484255909
• Edizione: [1st ed. 2020.]
• Descrizione fisica: 1 online resource (XVII, 406 p. 138 illus.)
• Disciplina: 005.756
• Soggetti: Database management; Microsoft software; Microsoft .NET Framework; Database Management; Microsoft and .NET
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• 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.