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

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