Sql 2012 Recipes 3Rd Edition

THE EXPERT’S VOICE® IN SQL SERVER

www.it-ebooks.info

For your convenience Apress has placed some of the front matter material after the index. Please use the Bookmarks and Contents at a Glance links to access them.

www.it-ebooks.info

Contents at a Glance
About the Authors....................................................................................................... xlixAbout the Technical Reviewers ......................................................................................li Acknowledgments ........................................................................................................liii Introduction ...................................................................................................................lv ■ Chapter 1: Getting Startedwith SELECT ......................................................................1 ■ Chapter 2: Elementary Programming ........................................................................23 ■ Chapter 3: NULLs and Other Pitfalls ..........................................................................41 ■ Chapter 4: Querying from Multiple Tables.................................................................57 ■ Chapter 5: Grouping and Summarizing .....................................................................79 ■ Chapter 6: Advanced Select Techniques....................................................................93 ■ Chapter 7: Aggregations and Windowing ................................................................115 ■ Chapter 8: Inserting, Updating,Deleting..................................................................147 ■ Chapter 9: Working with Strings .............................................................................179 ■ Chapter 10: Working with Dates and Times ............................................................197 ■ Chapter 11: Working with Numbers ........................................................................219 ■Chapter 12: Transactions, Locking, Blocking, and Deadlocking ..............................241 ■ Chapter 13: Managing Tables ..................................................................................273 ■ Chapter 14: Managing Views...................................................................................301 ■ Chapter 15: Managing Large Tables andDatabases................................................319 ■ Chapter 16: Managing Indexes ................................................................................341
iii www.it-ebooks.info

■ Contents at a GlanCe

■ Chapter 17: Stored Procedures ...............................................................................363 ■ Chapter 18: User-Defined Functions and Types.......................................................383 ■ Chapter 19: Triggers ................................................................................................415 ■ Chapter 20: Error Handling ......................................................................................447 ■ Chapter 21: Query Performance Tuning ...................................................................465 ■ Chapter 22: Hints.....................................................................................................507 ■ Chapter 23: Index Tuning and Statistics ..................................................................519 ■ Chapter 24: XML ......................................................................................................539 ■ Chapter 25: Files, Filegroups, and Integrity............................................................559 ■ Chapter 26: Backup .................................................................................................593 ■ Chapter 27: Recovery ..............................................................................................621 ■ Chapter 28: Principals and Users ............................................................................639 ■...