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
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...
-
I needed to convert some vbscript to javascript as firefox doesn't support vbscript. I found this online tool very helpful Beware tha...
-
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
-
What is Checksum? Checksum is a function available in sql server 2005 and sql server 2008. It is intended to build a hash index based on an ...
No comments:
Post a Comment