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.
For seven more years, until the day they finally migrated to Azure SQL DB, Lena would pass that old Itanium server and whisper: “Still enterprise, old friend.”
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?”
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.
For seven more years, until the day they finally migrated to Azure SQL DB, Lena would pass that old Itanium server and whisper: “Still enterprise, old friend.” sql server 2005 enterprise
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