Yasmin needed to fetch some data from a database for a report. Specifically, she needed to get all the order data. All of it. No matter how much there was.
The required query might be long running, but it wouldn’t be complicated. By policy, every query needed to be implemented as a stored procedure. Yasmin, being a smart prograammer, decided to check and see if anybody had already implemented a stored procedure which did what she needed. She found one called
GetAllOrders. Perfect! She tested it in her report.
Yasmin expected 250,000 rows. She got 10.
She checked the implementation.
CREATE PROCEDURE initech.GetAllOrders AS BEGIN SELECT TOP 10 orderId, orderNo, orderCode, … FROM initech.orders INNER JOIN… END
In the original developer’s defense, at one point, when the company was very young, that might have returned all of the orders. And no, I didn’t elide the
ORDER BY. There wasn’t one.
can centralize your organization’s software applications and components to provide uniform access to developers and servers.