Joey on SQL Server. Deep Dive into SQL Server 2022's Query Performance Features, Part 2: PSP Optimization. Reduce workload times with this handy feature that can benefit every database pro.

Server:DL380 G5 dual dual core 2.33Ghz, 4GB RAMWin2K3 Std R2 SP1 x64SQL 2005 Std SP2 x64This weekend the SQL box chewed through every last bit of memory ...

Grafting the in-memory technology into SQL Server itself will simplify the customer’s IT architecture because it eliminates the need to procure and maintain separate stand-alone in-memory ...

Hekaton, Microsoft's coming in-memory database engine, will be built into the next version of SQL Server. Meanwhile, SQL Server 2012 SP1 is now generally available.