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

GOVERNMENT OF RAJASTHAN TEACHER TRANSFER LIST 2014

Government of Rajasthan teacher transfer list 2014 first grade/ second grade/ panchyat raj/ 3rd grade/ LDC grade/ 2nd grade list teacher transfer Government of Rajasthan transfer list, Rajasthan 3rd grade teacher transfer, Rajasthan 1st grade teacher transfer, Rajasthan 2nd grade teacher transfer, Rajasthan LDC/UDC grade teacher transfer at http://rajshiksha.gov.in/.
Read more

Orientation change shortcuts for emulator and simulator

Image
Android Emulator: For Mac:     ctrl+fn+F11 to change the landscape to portrait and vice versa. For Windows 7:   left-ctrl+F11 FOr Linux: ctrl+F11 Note: Mac users, you only need to use the fn key if the setting "Use all F1, F2 etc. keys as function keys" (under System Preferences -> Keyboard) is checked. iPhone Simulator: Cmd-Left and Cmd-Right will rotate the virtual phone (simulator).
Read more

Constructor in C#

Introduction Broadly speaking, a constructor is a method in the class which gets executed when its object is created. Usually, we put the initialization code in the constructor. Writing a constructor in the class is damn simple, have a look at the following sample: public class mySampleClass { public mySampleClass() { // This is the constructor method. } // rest of the class members goes here. } When the object of this class is instantiated, this constructor will be executed. Something like this: mySampleClass obj = new mySampleClass() // At this time the code in the constructor will // be executed Constructor Overloading C# supports overloading of constructors, that means, we can have constructors with different sets of parameters. So, our class can be like this: public class mySampleClass { public mySampleClass() { // This is the no parameter constructor method. // First Constructor } public mySampleClass(int Age) { ...
Read more