Their legacy system required taking the Shipments table offline to rebuild indexes. With SQL Server 2005 Enterprise, Lena typed:
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. sql server 2005 enterprise
The old 32-bit Standard server crashed when tempdb hit 1.7GB. SQL Server 2005 Enterprise on 64-bit addressed terabytes of RAM. Lena watched Performance Monitor as the buffer pool grew to 28GB. Every join, every hash match, every sort happened in memory. Their legacy system required taking the Shipments table
“We stopped treating your data like a spreadsheet,” she said. Insert queries continued
“It’s just SQL Server with more zeros, right?” Marcus asked, loading the media.
Lena shook her head. “No. This is the Enterprise handshake. Watch.”
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: .