Rob Farley digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE..
Category: Execution Plans (3)
Continuing the EntryLevel challenge, Aaron Bertrand discusses optimizing the kitchen sink procedure with dynamic SQL and, optionally, OPTION (RECOMPILE).
Aaron Bertrand shows that, at least for a large number of...
Aaron Bertrand follows up on a recent post about the performance...
Aaron Bertrand explores yet another scenario where a date/time...
Following up on an earlier post about metadata, Aaron Bertrand reveals a few more of his sources for discovering changes in SQL Server.
Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.
Aaron Bertrand revisits whether or not ColumnStore can help pagination workloads.
Jason Hall shows off some of the new features in a brand new update for Plan Explorer.
Paul White goes into detail about another reason you'll want to use the NOEXPAND hint, even when using Enterprise Edition.
Paul White spends some time optimizing update queries in order to explore some SQL Server internals.
Aaron Bertrand highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in...
The SQL Server plan cache is one of the most important architectural elements for DBAs to understand. Get the slide deck and sample scripts here.
Paul White discusses some less well-known query optimizer features and limitations, and explains poor performance of certain hash join...
SQL Server MVP Matan Yungman shows ways to identify specific query bottlenecks while the query is running, mostly using native tools in SQL Server.
