Is it a good idea to run both SQL Server and IIS on the same physical server? - 10 Oct 2006

We have five SQL servers running on different physical servers. What are the downfalls for combining these SQL servers onto a single physical server? - 10 Oct 2006

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. - 10 Oct 2006

Do you have a recommendation for the maximum number of databases you can place on a single SQL Server? - 10 Oct 2006

Is it normal for the buffer cache size to vary throughout the day? - 10 Oct 2006

Is there a way to control which CPU performs what tasks in SQL Server? - 10 Oct 2006

We have a started experiencing a performance issue with a table that has now grown to over 600,000 rows. - 10 Oct 2006

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)? - 10 Oct 2006

We have had some performance problems with a server that is running Terminal Services, SQL Server, and Access databases. - 10 Oct 2006

How can I help identify the worst performing queries in my SQL Server database application? - 09 Oct 2006