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.

One of the most important differentiators amongst SQL Server 2014 and its earlier counterparts is in the former’s support for in-memory database tables. When our computer systems go slow we ...

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 ...

The second part of the book begins to dissect the core of SQL Server, providing you insight into SQL memory management, transactional support, cursors, and query processors.

To ease deployments, the next version of SQL Server will include a tool that allows database administrators to designate databases or individual tables that can be run in memory. No changes will ...

Hekaton, Microsoft's in-memory database for online transaction processing in SQL Server, can increase processing speeds up to 30x using a system’s main memory for faster access time.