Outstanding article. This is an essential task that all DBAs do eventually have to do.

This is some examples of a report that we had writing out using a cursor. This is based on a very real world example and I believe the savings...

The clustering solution I do not believe will work unless you set up an active/active cluster and then funnel all the data load through one machine. However, you will...

The DTS is part of the load that is going to take some of the time. It is not the most efficient way to move the data between sites....

From 400 KB to 50 MB is kind of a big expansion. How did it get imported at such a size? I take it that the access is...

One thing I forgot, the user in microsofts case is someone who is actively developing against the SQL Server. So if you have 5 developers developing then yes...

http://www.microsoft.com/sqlserver/2005/en/us/Pricing.aspx

This covers basic pricing. However, in you situation it would cost 49 dollars to develop and have people basically test against it. HOWEVER, if this becomes...

There is a way to have users have the same SID across servers that might solve your problem.

http://support.microsoft.com/kb/246133

Currently, I am not engaged in using VMware. I just was trying to use it about 4 years ago. I was hoping to get a better picture...

I was hoping to recieve from your article a more precise breakdown of how you are making virtualization work. I have been the guy trying to use VMWare server...

We have similar issues and have determined alot of the problem is the code running against the server. Poor code = poor performance.

Then restart the Sql Server agent. It is required to see the mail changes you made. It won't email to operators until after you restart the service.

Having been the Hero DBA I will agree it most heartily sucks. The biggest problem is that the lack of documentation that surrounds the Hero DBA is probably not...

Did you restart SQL server agent service after enabling the Database Mail?

I agree with the comments about increasing resource utilization on the database server. This is an issue of architecture and how you are going to address pagination. Within...