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 available. I came in this morning finding ...

Check this tip to increase the 'min memory per query' option to improve the performance of queries that use hashing or sorting operations, if your SQL Server has a lot of memory available and ...

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.