!free!: 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.

“You’re giving me a disc ?” she asked.

The nighttime indexing job that used to take four hours? The Aftermath