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.

More details are emerging about in-memory capabilities and how they boost performance in the new SQL Server 2014, announced at the recent TechEd 2013 conference and possibly due for a CTP this month.

During the PASS Summit 2012, a technical conference for SQL Server professionals, Microsoft announced Hekaton, an in-memory row-based data management system targeted at transaction processing (TP ...

Everybody wants their databases to retrieve and store information faster, and with SQL Server 2014, which is released to manufacturing today, Microsoft is tweaking its columnar data store as well as ...

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

If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want ...

In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system.

Leverage the power of the new in-memory OLTP engine included in SQL Server 2014 for faster performance and lower query latency ...

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.

Microsoft has RTM'd SQL Server 2014, which includes a new in-memory OLTP engine built jointly by Microsoft Research and the SQL Server team.