Before closing SSMS, she opened the Activity Monitor one last time. The CPU graph, once a frantic seismograph during the report’s runtime, now lay flat and calm. All was well in the realm of the relational engine.
Lena’s monitor glowed like a distant lighthouse in the dark ocean of her home office. Outside, the city slept. Inside, only the soft hum of her workstation and the steady click of her keyboard broke the silence. The culprit: a stored procedure that had run flawlessly for three years—until 7:13 PM on a Friday. mssql management studio
She highlighted the offending block—a scalar-valued function inside a WHERE clause. Of course. She’d warned the team a year ago. Scalar functions were row-by-row agony. But Mark, the senior dev who had since left for a startup, had called it "elegant." Before closing SSMS, she opened the Activity Monitor