Groupby Free Sql Server Training

The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer will make optimal choices. Often, the optimizer will stick an optional operator in a plan that just doesn’t belong. Sorts, Spools, Lookups, Tops, Aggregates, and Bitmaps can all end up where they don’t belong. Opt out of bad powerpoint decks with this demo-only session! Joe Obbish and Erik Darling will show you when the optimizer’s optics might require a trip to the optometrist.