MS SQL

Regain database Space

Posted on

The last two articles help you identify where the issue is? this one will take you through step by step process of what one may do to regain the space occupied by the databases. Hence freeing some resources on the SQL server and improving the performance too. Identify and clean Log/Temp Tables Truncate/Delete the log
Continue Reading..

MS SQL

Display data and log space information for each database – what’s eating up server space?

Posted on

This thread outlines how to display data and log space information for all the databases in SQL Server. This will give you an insight into which database needs to be maintained or dropped to save space on your server. Connect to the Database Engine. From the Standard bar, click New Query. Copy and paste the following example into the query window and click Execute. one may uncomment a
Continue Reading..

Windows

Disabling “Open File – Security Warning” Message box

Posted on

If you are working with remote machines and/or UNC path you may experience following dialog every time you try to open an EXE or batch file from a shared location: Let see how to disable this Open run prompt Type inetcpl.cpl and press enter Click the Security tab Click Custom Level… Select Enable (not secure) under Launching applications and unsafe files. Click OK Then Yes
Continue Reading..