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

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

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

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. This article dives into the happens-before ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...