03530nam 22005895 450 991038073490332120200702013255.09781484255902148425590910.1007/978-1-4842-5590-2(CKB)4100000010327468(DE-He213)978-1-4842-5590-2(MiAaPQ)EBC6109042(CaSebORM)9781484255902(PPN)242982077(OCoLC)1176246173(OCoLC)on1176246173(EXLCZ)99410000001032746820200212d2020 u| 0engurnn|008mamaatxtrdacontentcrdamediacrrdacarrierPro T-SQL 2019 Toward Speed, Scalability, and Standardization for SQL Server Developers /by Elizabeth Noble1st ed. 2020.Berkeley, CA :Apress :Imprint: Apress,2020.1 online resource (XVII, 406 p. 138 illus.) Includes index.9781484255896 1484255895 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.Database managementMicrosoft softwareMicrosoft .NET FrameworkDatabase Managementhttps://scigraph.springernature.com/ontologies/product-market-codes/I18024Microsoft and .NEThttps://scigraph.springernature.com/ontologies/product-market-codes/I29030Database management.Microsoft software.Microsoft .NET Framework.Database Management.Microsoft and .NET.005.756Noble Elizabethauthttp://id.loc.gov/vocabulary/relators/aut952610MiAaPQMiAaPQMiAaPQBOOK9910380734903321Pro T-SQL 20192153555UNINA