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

✍ Scribed by Jason Brimhall, David Dye, Jonathan Gennick, Andy Roberts, Wayne Sheffield (auth.)

• Publisher: Apress
• Year: 2012
• Tongue: English
• Leaves: 793
• Edition: 3
• Category: Library

✦ Synopsis

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

✦ Table of Contents

Front Matter....Pages i-lv
Getting Started with SELECT....Pages 1-21
Elementary Programming....Pages 23-39
NULLs and Other Pitfalls....Pages 41-55
Querying from Multiple Tables....Pages 57-78
Grouping and Summarizing....Pages 79-92
Advanced Select Techniques....Pages 93-113
Aggregations and Windowing....Pages 115-146
Inserting, Updating, Deleting....Pages 147-178
Working with Strings....Pages 179-195
Working with Dates and Times....Pages 197-217
Working with Numbers....Pages 219-240
Transactions, Locking, Blocking, and Deadlocking....Pages 241-271
Managing Tables....Pages 273-300
Managing Views....Pages 301-318
Managing Large Tables and Databases....Pages 319-340
Managing Indexes....Pages 341-362
Stored Procedures....Pages 363-382
User-Defined Functions and Types....Pages 383-413
Triggers....Pages 415-446
Error Handling....Pages 447-464
Query Performance Tuning....Pages 465-506
Hints....Pages 507-518
Index Tuning and Statistics....Pages 519-538
XML....Pages 539-557
Files, Filegroups, and Integrity....Pages 559-592
Backup....Pages 593-620
Recovery....Pages 621-637
Principals and Users....Pages 639-671
Securables, Permissions, and Auditing....Pages 673-723
Objects and Dependencies....Pages 725-736
Back Matter....Pages 737-751

✦ Subjects

Database Management