Category: Performance Tuning
Why does a query executed from VB run more slowly than when run from Query Analyzer?
What is the difference between a table and index scan in an execution plan?
What are the pros and cons of running more than one instance of SQL Server on a single physical server?
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?
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.
How can I capture performance data over time, and review it later?
The tempdb database grows so large I run out of disk space. What can I do?
How can I determine if a table is pinned in SQL Server memory or not?
Should I use CPU or elapsed time to measure query performance?