Monday, August 03, 2009

One of the functions of a DBA is to keep an eye on free space within the database and database files. The auto grow feature is great as a last resort, but proactively managing the database files is a better approach.

Also, this information can be used to shrink data files as needed if there is a lot of free space in the files. In this tip from MSSQLTIPS they take a look at a few ways to find the current free space within a database, so you can better manage your database files.... Read More

No comments:

Rerunning all subscriptions for a particular report that have failed.

Today I had a situation where a few of the subscriptions for a particular report have failed. I needed a script to run only these subscripti...