LEADER 03530nam 22005895 450 001 9910380734903321 005 20200702013255.0 010 $a9781484255902 010 $a1484255909 024 7 $a10.1007/978-1-4842-5590-2 035 $a(CKB)4100000010327468 035 $a(DE-He213)978-1-4842-5590-2 035 $a(MiAaPQ)EBC6109042 035 $a(CaSebORM)9781484255902 035 $a(PPN)242982077 035 $a(OCoLC)1176246173 035 $a(OCoLC)on1176246173 035 $a(EXLCZ)994100000010327468 100 $a20200212d2020 u| 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aPro T-SQL 2019 $eToward Speed, Scalability, and Standardization for SQL Server Developers /$fby Elizabeth Noble 205 $a1st ed. 2020. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2020. 215 $a1 online resource (XVII, 406 p. 138 illus.) 300 $aIncludes index. 311 08$a9781484255896 311 08$a1484255895 327 $aIntroduction -- 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. 330 $aDesign 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. 606 $aDatabase management 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 615 0$aDatabase management. 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 14$aDatabase Management. 615 24$aMicrosoft and .NET. 676 $a005.756 700 $aNoble$b Elizabeth$4aut$4http://id.loc.gov/vocabulary/relators/aut$0952610 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910380734903321 996 $aPro T-SQL 2019$92153555 997 $aUNINA