A business I support recently purchased an add on to the pos software they use. It uses .net 3 and sql server express 2005. Their support tech came out and installed some new hardware (not related to ...

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

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

How about “Dude, Where Is My Memory? Understanding Microsoft SQL Server Memory Usage and Management” by Maciej Pilecki. I thought SQL Server just grabbed all the memory it could and never gave it back ...

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

Just a few months after launching SQL Server 2012, Microsoft is starting to peel back the covers on what's coming in the next version of its database. And while the Softies aren't sharing a due date, ...

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

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