• Shaarli
  • Tag cloud
  • Picture wall
  • Daily
  • RSS
  • Login
4334 shaares
Filters

Carrying Baggage Through Query Plans: Why Wide Queries Get Heavy

QRCode

Learn why SQL Server execution plans carry too many columns through expensive operations like sorts and hash joins, causing memory grants and slow query performance. Discover two techniques to optimize wide queries using temp tables and derived tables.

https://kendralittle.com/2026/01/19/carrying-baggage-through-query-plans-why-wide-queries-get-heavy/
January 26, 2026 at 1:25:02 PM EST *
mssql sql
FILLER
Shaarli · The personal, minimalist, super fast, database-free, bookmarking service by the Shaarli community · Documentation
Fold Fold all Expand Expand all Are you sure you want to delete this link? Are you sure you want to delete this tag? The personal, minimalist, super fast, database-free, bookmarking service by the Shaarli community