How to find the free space in Database files?


01 select
02 a.FILEID,
03 [FILE_SIZE_MB] =
04 convert(decimal(12,2),round(a.size/128.000,2)),
05 [SPACE_USED_MB] =
06 convert(decimal(12,2),round(fileproperty(a.name,'SpaceUsed')/128.000,2)),
07 [FREE_SPACE_MB] =
08 convert(decimal(12,2),round((a.size-fileproperty(a.name,'SpaceUsed'))/128.000,2)) ,
09 NAME = left(a.NAME,15),
10 FILENAME = left(a.FILENAME,30)
11 from
12 dbo.sysfiles a

The Script will provide you how much space is actually being used and how much is still available for it to grow further.

Comments

Post a Comment

Popular posts from this blog

EBITDA

EBITDA - Earnings Before Interest, Taxes, Depreciation, and Amortisation. Interest: the company would have borrowed money. This is the amount it needs to pay back. Taxes: the company owes the government some taxes. Depreciation: the company owns assets. These would differ from industry to industry. But the assets lose value over time. Like say a company car – it would lose its value with time. Companies have machinery, vehicles, computers, and even furniture that lose value with time. Amortization: this refers to the cost of intangible assets like patents, copyrights, etc.
Read more

__doPostBack Function

Introduction It is quite amazing to note that only two of the ASP.NET web server controls cause a postback. All the other controls use the JavaScript __doPostBack function to trigger the postback. In this article you will learn about the __doPostBack function and how it works. _doPostBack Function The best way to understand the working of the __doPostBack function is to dissect the function into small pieces and explore each piece one at a time. Let us take a look at the function. Listing 1 - _The __doPostBack function function __doPostBack(eventTarget, eventArgument) { if (!theForm.onsubmit || (theForm.onsubmit() != false)) { theForm.__EVENTTARGET.value = eventTarget; theForm.__EVENTARGUMENT.value = eventArgument; theForm.submit(); } } Analysis The __doPostBack function takes two arguments, eventTarget and eventArgument. The eventTarget contains the ID of the control that causes the postback and the eventArgument contains any additional data associated with the control. Note that...
Read more

How to create a bash profile

A typical install of OS X won't create a .bash_profile for you. When you want to run functions from your command line, this is a must have. Start Terminal Type "cd ~/" to go to your home folder Type "touch .bash_profile" to create your new file. Open the file " open -e .bash_profile" . it will open in TextEdit Type ". .bash_profile" or "source ~/.bash_profile" to reload .bash_profile and update any functions you add. You can add functions as below: ANDROID_NDK=/Applications/android-ndk PATH=$ANDROID_NDK:/Application/apache-ant/bin:/Applications/android-sdk/tools:/Applications/android-sdk/platform-tools:~/Library/Application\ Support/Titanium/mobilesdk/osx/2.0.1.GA2:$PATH alias ddms="/Applications/android-sdk/tools/ddms" alias titanium="/Users/jakir.hussain/Library/Application\ Support/Titanium/mobilesdk/osx/2.0.1.GA2/titanium.py"
Read more