Author: jwokelly
Why does a query executed from VB run more slowly than when run from Query Analyzer?
Why does the performance of some queries vary so widely?
Why doesn't query parellelism use all of the available CPUs?
What is the difference between SQL Server 2000 standard and enterprise editions?
Should I use CPU or elapsed time to measure query performance?
How can I determine if a table is pinned in SQL Server memory or not?
The tempdb database grows so large I run out of disk space. What can I do?
How can I capture performance data over time, and review it later?
At what point should I worry about page splits, and what can I do to help reduce them?