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

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

Last year, Microsoft officials said the next version of its SQL Server database would include built-in in-memory online transaction processing (OLTP) technology. That was all they'd say at that point ...

Windows System Resource Manager lets you create policies for processor and memory usage to control how applications divvy up limited resources. Russell Smith is a technology consultant and trainer ...