Upcoming Events
2024-11-04 @ 09:00 - 17:00
Whether you’re aiming to be the next great query tuning wizard or you simply need to tackle tough business problems at work...read more
2024-11-05 @ 09:00 - 17:00
Picture this: a day crammed with fun, fascinating demonstrations for SQL Server and Azure SQL. This isn’t your typical training day; this session follows the mantra of “learning by doing,” with...read more
2024-09-06 @ 09:00 - 17:00
Whether you want to be the next great query tuning wizard, or you just need to learn how to start solving tough business problems at work, you need a solid understanding of not only what makes things fast, but also what makes them slow.
Great post Erik! We use this trick, often it’s really effective! Sometimes it also runs loads faster because when we do this we also remove the ORDER BY when we do the SELECT INTO.
This is exactly the same trick I came up with for my developers two weeks ago. It does really help!