SQL Server FAQ
We have had some performance problems with a server that is running Terminal Services, SQL Server, and Access databases.
Should I schedule the indexes in my SQL Server databases to be rebuilt before or after the statistics on my tables are updated (or does it matter)?
We have a started experiencing a performance issue with a table that has now grown to over 600,000 rows.
Do you have a recommendation for the maximum number of databases you can place on a single SQL Server?
When I run a stored procedure in Query Analyzer, it runs in about two minutes. But if I execute the same stored procedure as a job, it runs several hours.