The old one had taken nine minutes.
She created a non-clustered columnstore index on the fly. Not on the main Prod table—she wasn't insane—but on a snapshot replica. Then she used WITH (NOEXPAND) to trick the optimizer into using it. sql 2019 developer
But at 11:47 PM on a Friday, staring at a stored procedure written in what looked like ancient Sumerian, she accepted the truth. The company’s entire inventory pipeline ran on SQL Server 2019, and it was dying. The old one had taken nine minutes