“You’re giving me a disc ?” she asked.
“That’s Enterprise,” Lena said.
Their flagship product—a logistics tracker for intermodal freight—was running on SQL Server 2000 Standard Edition. The database had grown to 350GB. Every night, the indexing job took four hours. Every morning, the dispatchers in Chicago and Rotterdam would sit staring at spinning hourglasses while containers piled up at ports. sql server 2005 enterprise
CREATE DATABASE Northwind_Snapshot ON ( NAME = Northwind_Data, FILENAME = 'E:\Snapshots\NW_SS1.ss' ) AS SNAPSHOT OF Northwind; Within seconds, she restored the lost rows from the snapshot. No backups restored. No downtime. The dev kept his job—barely. “You’re giving me a disc
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?” The database had grown to 350GB
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?”
