Is there any option to release the additional memory that has been used by SQL Server after a query is completed? - 09 Oct 2006

Is there a way to configure memory cache or buffers per database? - 09 Oct 2006

I’m a newbie to SQL Server performance monitoring. With all the information on your website, I don’t know where to start. - 09 Oct 2006

I am hoping that you may be able to assist me in evaluating the needs of our school district that is purchasing a software package that uses SQL Server as the backend database. - 06 Oct 2006

We run an ERP program that uses SQL Server as the backend database. Does how the ERP program is designed and written affect its performance with SQL Server? - 06 Oct 2006

What are the pros and cons of running more than one instance of SQL Server on a single physical server? - 06 Oct 2006

What is the difference between a table and index scan in an execution plan? - 06 Oct 2006

Why does a query executed from VB run more slowly than when run from Query Analyzer? - 06 Oct 2006

Why does the performance of some queries vary so widely? - 06 Oct 2006

Why doesn’t query parellelism use all of the available CPUs? - 05 Oct 2006