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...
How to know whether my indexes are being used or not? This is most interesting question I have come across through the forums since the SQL 2000 version usage days, you may not have easy way to find out using SQL Server 2000 or even you have to run a
Read More...