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. I came in ...

If tables within the database grow beyond the amount of memory you can allocate to the SQL Server instance, the table isn't a good candidate for in-memory OLTP tables. In-memory OLTP tables ...