Server:<BR>DL380 G5 dual dual core 2.33Ghz, 4GB RAM<BR>Win2K3 Std R2 SP1 x64<BR>SQL 2005 Std SP2 x64<BR><BR>This weekend the SQL box chewed through every last bit of memory available.

After a few months without a reboot, its at 44% usage of physical memory according to task manager. I know this doesn't represent the amount of RAM the SQL Server processes need, just how much it ...

With (Memory_Optimized = On; By default, setting the Memory_Optimized option creates a durable table. If you're willing to lose all of your data when SQL Server shuts down you can add a Durability ...