I am not a System Administrator, but I am temporarily trying to fill that role. I have 2 Windows 2003 Servers. 1 server has my Microsoft SQL Database (SQL Server 2005) and the other is the web ...
A colleague is attempting to update our server's SQL Server 2008 version 10.0.1600.22 (not R2) install up to SP3. Unfortunately, we can't work out where the "Update" button is; the installer seems to ...
On a SQL Server 2005 machine, I have DBMail setup and correctly configured. I am able to use "Notify Operator" and EXEC msdb.dbo.sp_send_dbmail to queue emails. But the problem is the queued mails ...
What are the best tools and processes for periodically monitoring and troubleshooting sql server performance issues?