As we know you have SP_RECOMPILE to re-compile the stored procedures within the database and DBREINDEX statement to reindex the fragmented indexes. How about refreshing the views that are modified on day-to-day basis within a database? You can take help
Read More...
You may be aware that SP_READERRORLOG can be used from a query analyzer or query editor to read the error log contents without opening the file on the disk or from Management Studio (or Enterprise Manager). I'm not sure whether you have observed that
Read More...