On go-live morning, the Union Pacific dispatcher in Omaha pulled up the dashboard. It loaded in 0.3 seconds. He blinked, refreshed, and called Lena: “What did you do?”
Lena, the senior DBA, was summoned to the CEO’s glass-walled office. “Fix it, or we lose the Union Pacific contract,” he said, sliding a branded DVD across the table. The disc read: .
CREATE PARTITION FUNCTION pf_Weekly (datetime) AS RANGE RIGHT FOR VALUES ('2006-01-01', '2006-01-08', ...); Suddenly, a query for last Tuesday’s data touched only one partition. The I/O dropped from 800 MB to 12 MB. Dispatchers called the helpdesk: “Did someone upgrade the network?” sql server 2005 enterprise
ALTER INDEX IX_Shipments_ETA ON Shipments REBUILD WITH (ONLINE = ON); Marcus stared. The table remained live. Insert queries continued. Updates flowed. The index rebuilt itself in the background like a mechanic changing tires on a moving truck.
“We stopped treating your data like a spreadsheet,” she said. On go-live morning, the Union Pacific dispatcher in
Lena shook her head. “No. This is the Enterprise handshake. Watch.”
She had created a snapshot just before lunch. “Fix it, or we lose the Union Pacific
A junior dev accidentally ran DELETE FROM Shipments WHERE ETA < '2005-01-01' without a transaction. Lena’s hands hovered over the keyboard. Then she remembered: Database Snapshots .