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

Understanding Top line and Bottom line?

Understanding Top line and Bottom line? Top line – It’s the revenues generated by a company or what you might call the gross sales. When people talk about the company’s “topline growth”, they refer to an increase in its gross sales or revenues. When companies speak about the need to increase their topline, they are discussing about the need to focus on generating/increasing sales. This is money that is coming in before any expenses are deducted. Bottom line – The bottom line is the income that is left after all expenses have been deducted. You might also call this the company’s net profit. Some of the expenses that are usually being deducted are things like loan repayments, loan interests, administrative costs, taxes and even salary to employees. So there could be a big difference between the Top line revenues and the Bottom line revenues. A company’s bottomline can also be referred to as net earnings. Bottomline usually shows the efficiency of the company in controlling ...
Read more

How to activate PF UAN account

Image
1. Go here... http://uanmembers.epfoservices.in/ 2. Select "activate your UAN" 3. Enter your UAN, Mobile no., select Delhi - South as state (or your PF office), Then enter your  PF number (middle box will be empty). as shown below in picture 4. Get PIN on your mobile number 5. Enter PIN and submit 5. Enter your email address and create password Thanks, Jakir
Read more

Scrum Master vs Product Owner

The most common confusion in the 2 roles of Agile-SCRUM is between Scrum Master & Product Owner. The Scrum Master is in charge of making sure the Scrum process is followed. The Product Owner (PO) is the person in charge of making sure the product succeeds in the direction the company wants to go. The PO does this by setting priorities of product backlog items, making sure all needed parties are there for both the sprint planning and sprint review (both are very important). If something occurs and either the scope explodes or decisions need to be made, the PO is the person who gives the answers to the decisions. Product owner act as the feature prioritize(r) and main point of contact between business/customer and IT team. If product not succeed and probably reason is prioritization issue then product owner may be "single wringable neck" person. The Scrum Master is making sure the process gets followed and working through the adaptation of Scrum to your organization. By do...
Read more