LEADER 06072 am 22007213u 450 001 9910309959503321 005 20200520144314.0 010 $a1-78040-536-7 035 $a(CKB)3780000000054600 035 $a(EBL)3425866 035 $a(SSID)ssj0001578730 035 $a(PQKBManifestationID)16254750 035 $a(PQKBTitleCode)TC0001578730 035 $a(PQKBWorkID)14861275 035 $a(PQKB)10109289 035 $a(MiAaPQ)EBC3425866 035 $a(Au-PeEL)EBL3425866 035 $a(CaPaEBR)ebr11080174 035 $a(OCoLC)929497022 035 $a(ScCtBLL)a7be3c7d-90ca-4849-b227-a82a71b2fdec 035 $a(EXLCZ)993780000000054600 100 $a20150804h20152015 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aRainwater tank systems for urban water supply $edesign, yield, energy, health risks, economics and social perceptions /$fedited by Ashok K. Sharma, Donald Begbie and Ted Gardner 210 1$aLondon, [England] :$cIWA Publishing,$d2015. 210 4$dİ2015 215 $a1 online resource (300 p.) 300 $aDescription based upon print version of record. 311 $a1-78040-535-9 320 $aIncludes bibliographical references at the end of each chapters and index. 327 $a""Cover""; ""Copyright""; ""Contents""; ""Editors""; ""List of Authors""; ""Foreword""; ""Preface""; ""Editorial""; ""Chapter 1: Rainwater harvesting systems for urban developments""; ""1.1 Introduction""; ""1.2 International Experiences with Rainwater Harvesting Systems""; ""1.3 The Australian Experience with Rainwater Tank Systems""; ""1.4 Key Issues for Greater Uptake of Rainwater Tank Systems""; ""1.4.1 Estimating rainwater system yield and mains water savings""; ""1.4.2 Understanding the risks associated with rainwater quality""; ""1.4.3 Guidelines for managing risks of rainwater use"" 327 $a""1.4.4 Evaluating the cost-effectiveness of rainwater tanks""""1.4.5 Understanding the indirect costs and benefits of rainwater tanks (externalities)""; ""1.4.6 Impact of rainwater systems on stormwater flows and nutrient loads""; ""1.4.7 Impact of rainwater tank systems on centralised water systems and water quality""; ""1.4.8 Energy consumption in rainwater tank systems""; ""1.5 Conclusions""; ""1.6 References""; ""Chapter 2: Rainwater tank modelling""; ""2.1 Introduction""; ""2.2 General Concepts Underlying A Rain Water Tank Model""; ""2.3 Aspects of Some Existing Rain Water Tank Models"" 327 $a""2.3.1 Time-step and climate data inputs""""2.3.2 Water demand data inputs""; ""2.3.3 Roof runoff modelling""; ""2.3.4 Tank water balance configurations""; ""2.3.5 Model outputs""; ""2.4 Influence of Different Variables in the Tank Simulation""; ""2.4.1 Time-step and spill rule""; ""2.4.2 Roof area""; ""2.4.3 Tank size""; ""2.4.4 Demand""; ""2.4.5 Initial and continuing losses""; ""2.4.6 Simulation length""; ""2.4.7 Validation""; ""2.5 Upscaling of Rainwater Tank Behaviour to Multiple Tanks""; ""2.6 Conclusions""; ""2.7 References"" 327 $a""Chapter 3: Quantifying mains water savings from residential rainwater tanks""""3.1 Introduction""; ""3.1.1 Why quantify mains water savings?""; ""3.1.2 Previous studies on mains water savings""; ""3.1.3 Chapter objectives and scope""; ""3.2 Case Study 1 - Desktop Analysis of Mains Water Savings""; ""3.2.1 Background""; ""3.2.2 Methods""; ""3.2.3 Results""; ""3.2.4 Discussion and implications""; ""3.2.5 Limitations of Case Study 1""; ""3.2.6 Concluding remarks""; ""3.3 Case Study 2 - Benchmark Analysis of Mains Water Savings""; ""3.3.1 Background""; ""3.3.2 Research aims""; ""3.3.3 Methods"" 327 $a""3.3.4 Results and discussion""""3.3.5 Challenges and limitations""; ""3.3.6 Concluding remarks""; ""3.4 Case Study 3 - Water Savings from Rebated Rainwater Tanks""; ""3.4.1 Background""; ""3.4.2 Methods""; ""3.4.3 Mains water savings results""; ""3.4.4 Interpretation and implications""; ""3.4.5 Challenges and limitations""; ""3.4.6 Concluding remarks""; ""3.5 Key Considerations in Quantifying Mains Savings""; ""3.5.1 Quality of the datasets""; ""3.5.2 Mixed method and analyses""; ""3.5.3 Sample size v quality of datasets""; ""3.6 Summary and Conclusions""; ""3.7 References"" 327 $a""Chapter 4: Monitoring of household rainwater tank systems for rainwater usage"" 330 $aRainwater tank systems have been widely adopted across the world to provide a safe local source of water in underdeveloped rural areas, and as a substitution for mains water for non potable end uses in water stressed urban areas. They also provide flood control in monsoonal climates like Korea or in combined sewer systems like in Germany. The importance of these systems in cities has grown, as water managers seek to provide a range of decentralised solutions to supply constraints of current water supply systems, whilst reducing the impact of urban development on the natural environment, and increasing resilience to climate change. Rainwater Tank Systems for Urban Water Supply is based on a comprehensive, multi-million dollar research program that was undertaken in South East Queensland (SEQ) Australia in response to the Millennium drought when the water supply level in the regions drinking water dams dropped to 17% in July 2007 and the area came close to running out of water. 606 $aWater harvesting 606 $aRainwater 606 $aTanks 606 $aCisterns 606 $aMunicipal water supply 608 $aElectronic books. 615 0$aWater harvesting. 615 0$aRainwater. 615 0$aTanks. 615 0$aCisterns. 615 0$aMunicipal water supply. 676 $a628.142 702 $aSharma$b Ashok K. 702 $aBegbie$b Donald 702 $aGardner$b Theodore Roosevelt 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910309959503321 996 $aRainwater tank systems for urban water supply$92061540 997 $aUNINA LEADER 03991nam 22005655 450 001 9910338003403321 005 20200707003854.0 010 $a9781484243183 010 $a1484243188 024 7 $a10.1007/978-1-4842-4318-3 035 $a(CKB)4100000007334960 035 $a(DE-He213)978-1-4842-4318-3 035 $a(MiAaPQ)EBC5626659 035 $a(CaSebORM)9781484243183 035 $a(PPN)232967806 035 $a(OCoLC)1088729745 035 $a(OCoLC)on1088729745 035 $a(EXLCZ)994100000007334960 100 $a20181227d2019 u| 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aDynamic SQL $eApplications, Performance, and Security in Microsoft SQL Server /$fby Edward Pollack 205 $a2nd ed. 2019. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2019. 215 $a1 online resource (XX, 496 p. 128 illus.) 311 08$a9781484243176 311 08$a148424317X 327 $a1. What is Dynamic SQL? -- 2. Protecting Against SQL Injection -- 3. Large Scale Searching -- 4. Permissions and Security -- 5. Managing Scope -- 6. Performance Optimization -- 7. Scalable Dynamic Lists -- 8. Parameter Sniffing -- 9. Dynamic PIVOT and UNPIVOT -- 10. Solving Common Problems -- 11. Applications of Dynamic SQL -- 12. Index Usage and Maintenance. . 330 $aTake a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability. Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability. Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization?s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. What You'ill Learn: Build flexible applications that respond to changing business needs Take advantage of creative, innovative, and productive uses of dynamic SQL Know about SQL injection and be confident in your defenses against it Address performance concerns in stored procedures and dynamic SQL Troubleshoot and debug dynamic SQL to ensure correct results Automate your administration of features within SQL Server. 606 $aMicrosoft software 606 $aMicrosoft .NET Framework 606 $aDatabase management 606 $aMicrosoft and .NET$3https://scigraph.springernature.com/ontologies/product-market-codes/I29030 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 615 0$aMicrosoft software. 615 0$aMicrosoft .NET Framework. 615 0$aDatabase management. 615 14$aMicrosoft and .NET. 615 24$aDatabase Management. 676 $a004.165 700 $aPollack$b Edward$4aut$4http://id.loc.gov/vocabulary/relators/aut$01061083 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910338003403321 996 $aDynamic SQL$92517360 997 $aUNINA