If you want to reduce CPU usage in SQL Server, the best thing you can do is take note of the background applications. You can open Task Manager and kill any redundant or unnecessary applications ...

Once SQL Server is installed and all windows are closed, the CPU usage never drops below 20% in VMM. I was puzzled by this for some time, probably longer than I should have been.

If you've been managing databases for any length of time, you've probably had to contend with the 'noisy neighbors' scenario. In this scenario, you have several applications, each with their own ...