I'm having a nightmare trying to troubleshoot what appears to be a nasty memory leak on a SQL Server that was supposed to go into production weeks ago. I'm going out of my mind trying to fix this, and ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Birgitta Böckeler, Distinguished Engineer at ...

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

New in-memory online transaction processing (OLTP) improvements highlight the new features in the latest Community Technology Preview (CTP) of SQL Server 2016, the flagship RDBMS from Microsoft. SQL ...

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...

Knowing exactly what in-memory OLTP tables are used for will help you make the most of one of SQL Server's newest features. While in-memory online transaction processing (OLTP) tables may sound like a ...

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