SQL Server 2012 T-SQL Recipes - A Problem-Solution Approach

SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, developing triggers, and applying aggregate functions. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Newly updated for SQL Server 2012
• Comprehensive: Covers all common T-SQL problem domains

List of contents

1. Getting Started with SELECT


2. Elementary Programming


3. Nulls and Other Pitfalls


4. Combining Data from Multiple Tables


5. Grouping and Summarizing


6. Advanced SELECT Techniques


7. Query Techniques for Reporting


8. Inserting, Updating, Deleting


9. Working with Strings


10. Working with Dates


11. Working with Numbers


12. Transactions, Locking, Blocking, Deadlocking


13. Managing Tables


14. Managing Views


15. Managing Indexes


16. Managing Large Tables


17. Stored Procedures


18. User-Defined Functions


19. Triggers


20. Error Handling


21. Query Performance


22. Hints


23. Index Tuning and Statistics


24. XML


25. Files, Filegroups, and Integrity


26. Backup


27. Recovery


28. Principals and Users


29. Securables and Permissions


30. Objects and Dependencies

About the author

Jonathan Gennick war er mehr als zehn Jahre als Programmierer von relationalen Datenbanken tätig. Mit Oracle arbeitet er seit 1994.

Product details

• Authors: Jaso Brimhall, Jason Brimhall, Davi Dye, David Dye, Jonathan Gennick, Timothy Roberts, Timothy et al Roberts, Joseph Sack, Wayne Sheffield
• Publisher: Springer, Berlin
• Languages: English
• Product format: Paperback / Softback
• Released: 29.01.2013
• EAN: 9781430242000
• ISBN: 978-1-4302-4200-0
• No. of pages: 808
• Dimensions: 194 mm x 42 mm x 236 mm
• Weight: 1365 g
• Illustrations: LIII, 808 p. 22 illus.
• Series: The Expert's Voice in SQL Server; The Expert's Voice in SQL Server
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > IT; A, Database Management, database programming, Professional and Applied Computing