GilaMonster (11/23/2013)

---

Is the database going to grow again? If not, if you never expect it to get back to the 450GB, then do a once-off shrink. Be sure to leave...

update table1

set field1 = Field1 - Field1 * 2

It should work some extent.