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

To delete all .svn folder in Linux

To delete all .svn folder in Linux just follow the steps below:- Start Terminal change your current directory to your project folder (ex: /Users/me/Sites/project_a) type find ./ -name ".svn" | xargs rm -Rf and enter. Done, all your .svn folder has been deleted. By the way, you also can apply this method to remove all .svn folder in Mac machine.
Read more

Eclipse useful shortcuts

Ctrl+Shift+R Find Resource Use this to look for XML files, text files, or files of any other type. which are in your workspace. Ctrl+O Quick Outline Use this to find a method or a member variable in a class. Start typing to limit the choices. Press Ctrl+O a second time to include inherited methods. Ctrl+Shift+T Find Java Type Start typing the name and the list gets smaller. Try typing the capital letters of the class only (e.g. type "CME" to find "ConcurrentModificationException") Ctrl+E Open Editor Drop-Down Presents a popup window listing currently opened files. Start typing to limit the list or simply use the down arrow key. Ctrl+Space Content Assist Context sensitive content completion suggestions while editing Java code. Ctrl+Shift+Space Context Information ...
Read more

HttpHandler and HttpModule

Introduction Whenever a request reaches an Microsoft Internet Information Services (IIS) Web server, IIS determines how to handle the file by examining the requested file's extension. Static files, like HTML pages, images, Cascading Style Sheet (CSS) files, and the like, are handled directly by IIS. Requests for Microsoft ASP.NET Web pages or Web services—files with extensions .aspx or .asmx—are handed off to the ASP.NET engine. Requests for files with the extension .asp are handed off to the classic ASP engine. The ASP.NET and ASP engine are responsible for generating the markup for the requested resource. For ASP.NET and classic ASP Web pages, this markup is HTML; for Web services, the markup is a SOAP response. Once the engine has successfully rendered the markup for the requested resource, this markup is returned to IIS, which then sends the markup back to the client that requested the resource. This model of serving content—having IIS directly serve only static content, ...
Read more