• Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to secondary navigation
  • Skip to primary sidebar

OnlineProgrammingBooks.com

Legally Free Computer Books

  • All Categories
  • All Books
  • All Categories
  • All Books
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact
You are here: Home ▶ Databases ▶ Complete Showplan Operators

Complete Showplan Operators

December 11, 2011

Free SQL Server eBook: Complete Showplan Operators

Another free ebook from Simple Talk Publishing High Performance SQL Server series, “Complete Showplan Operators” by Fabiano Amorim can be downloaded in PDF and ePub formats.

Book Description

Writing good TSQL code is not an easy task. Then you submit the code to the query optimizer and strange things happen. The one good view you have into what the optimizer decided to do is provided by the execution plans. Understanding execution plans is a lot of work. Trust me on that. What you need to really understand your queries is as much knowledge as you can get. That’s where this excellent collection of articles on some of the more common execution plan operators comes in.

Fabiano Amorim has taken the time to really drill into the behavior of a small set of execution plan operators in an effort to explain the optimizer’s behavior. He’s explored why things happen, how you can change them, positively or negatively, and he’s done it all in an approachable style. You want information and knowledge in order to achieve understanding.

Table of Contents

  • Assert
  • Concatenation
  • Compute Scalar
  • BookMark/Key Lookup
  • Spools – Eager Spool
  • Compute Scalar
  • BookMark/Key Lookup
  • Eager Spool
  • Lazy Spool
  • Non-Clustered Index Spool
  • Row Count Spool
  • Stream Aggregate.
  • SORT
  • Merge Join
  • Merge Interval
  • Split, Sort, Collapse

Download Free PDF / Read Online

Author(s): Fabiano Amorim
Format(s): PDF, ePub
File size: 8.57 MB
Number of pages: 142
Link: Download.

Similar Books:

  1. SQL Server Execution Plans
  2. Dissecting SQL Server Execution Plans
  3. Brad’s Sure Guide to SQL Server Maintenance Plans
  4. Complete CSS Guide
  5. ASN.1 Complete
Previous Post: « Guide to NumPy
Next Post: More with symfony 1.3 & 1.4 »

Primary Sidebar

Get Latest Updates

  • Facebook
  • Pinterest
  • RSS
  • Twitter
  • YouTube
  • About Us
  • Privacy policy
  • Disclaimer
  • Subscribe
  • Contact

Copyright © 2006–2025 OnlineProgrammingBooks.com