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 » Internals » Query Optimizer » Query Plans   (RSS)
  • Mastering Execution Plan Analysis - Lisbon, Portugal 15 May 2015

    I will be presenting a full day workshop, “Mastering Execution Plan Analysis” on Friday 15 May 2015 as part of SQL Saturday #369 in Lisbon, Portugal. Early-bird tickets are priced at just €135 and are available until 28 February 2015, when the price increases to the regular rate of €150. Tickets can be purchased via EventBrite (where the full ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on January 13, 2015
  • 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
  • Forcing a Parallel Query Execution Plan

    This post is for SQL Server developers who have experienced the special kind of frustration, which only comes from spending hours trying to convince the query optimizer to generate a parallel execution plan.  This situation often occurs when making an apparently innocuous change to the text of a moderately complex query; a change which ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on December 22, 2011
  • A Tale of Two Index Hints

    If you look up Table Hints in Books Online, you’ll find the following statement: If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek. If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error. The interesting thing there is ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on September 22, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement