Below script will help to get the Database mdf & ldf files size, used space, Free space in MB.
If we have free space in the file then will shrink to reclaim the space.
I used the same script in one of my environment to get details for used and free space in the file.
If huge free space in master datafile then shrink the file and run rebuild index.
Note: It should be done in non business hours only.
Use DB_Name-- Mention database name to get the details go select name , filename, (growth/1024) as Growth_MB , convert(decimal(12,3),round(sf.size/128.00,2)) as FileSize_MB , convert(decimal(12,3),round(fileproperty(sf.name,'SpaceUsed')/128.00,2)) as SpaceUsed_MB , convert(decimal(12,3),round((sf.size-fileproperty(sf.name,'SpaceUsed'))/128.00,2)) as FreeSpace_MB from dbo.sysfiles sf
2025-02-27
5 reads
Write for SQLServerCentral - we're looking for new writers for SQL Server articles, scripts and questions.
2019-03-25
10,320 reads
It depends. The mantra of many DBAs and others in IT. Steve Jones reminds us why it applies.
2020-06-23 (first published: 2009-03-25)
556 reads
Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.
2005-08-17
11,060 reads
I was talking with the people over at Idera a few weeks ago and they mentioned that their CEO would be happy to give us a few minutes of his time. So I took them up on the offer and built a list of questions about Idera and SQL Server 2005. Take a moment to learn about the vendor view of the world and the impending release of SQL Server 2005.
2005-03-15
6,129 reads
