SQL Server FAQ
For best performance, should we install Analysis Service and the cubes as the same server as the production database?
A view runs on our development server in 30 seconds, but it takes over 10 minutes on the production server. Why?
We have an IBM Netfinity server with two network cards. One network connection changes from 100MBs to 10MBs. Is this normal?
I'm a newbie to SQL Server performance monitoring. With all the information on your website, I don't know where to start.
Is there any option to release the additional memory that has been used by SQL Server after a query is completed?