Snippets of the day – Wednesday, December 18, 2013

Posted on Posted in Snippets

code-snippet

Here are some of the most recently published snippets!

Check the DB Size of a MS SQL Server instance

This stored procedure retrieves some interesting figures regarding the size of the current database both in terms of file sizes and available space.
It also stores the results into a table named DBSize in order to keep a story of such figures (e.g. It can be invoked in a maintenace plan…)

Open the snippet

Author:    cghersi

How to correctly Shrink Log File for SQL Server

In case your transaction log reaches abnormal dimension (e.g. you forgot the backup of the log in your maintenace plan…) it is highly useful this script that allows you to safely shrink the transaction log to the wanted dimension

Open the snippet

Author:    cghersi

Leave a Reply

Your email address will not be published. Required fields are marked *