THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Query Plans » Aggregates » Internals   (RSS)
  • Fun with Aggregates

    There are interesting things to be learned from even the simplest queries.  For example, imagine you are given the task of writing a query to list AdventureWorks product names where the product has at least one entry in the transaction history table, but fewer than ten. One possible query to meet that specification is: SELECT ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on March 11, 2012
  • Row Goals and Grouping

    You might recall (from my last post) that query plans containing a row goal tend to favour nested loops or merge join over hashing.  This is because a hash join has to fully process its build input (to populate its hash table) before it can start probing for matches from its second input.  Hash join therefore has a high start-up cost, ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on August 22, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement