Friday, June 15, 2007 - Posts
On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located
Read More...
I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and
Read More...