SELECT name ,size/128.0 - CAST(FILEPROPERTY (name, 'SpaceUsed')

Syntax to find the used space and free space of the Data
file in a database(SQL Server). Following queries didn't
give the exact Used space and Free Space Information
sp_spaceused;DBCC showfilestats;exec
MyDbName.dbo.sp_spaceused;SP_HELPFILE

Can any one tell me the query for how to find the exact
used data file space and free space in a Data File?

Question Posted / narasimha

2 Answers
7947 Views
Cognizant, I also Faced
E-Mail Answers

Answer Posted / narasimha

SELECT name ,size/128.0 - CAST(FILEPROPERTY
(name, 'SpaceUsed') AS int)/128.0 AS AvailableSpaceInMB
FROM sys.database_files;

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between nvl and nvl2?

1024

Explain the various types of concurrency problem?

1238

How to loop through returning rows?

1085

What are trace files?

1002

Can multiple columns be used in sql group by clause in ms sql server?

1114

What is a non clustered primary key?

972

Explain the dirty pages?

1050

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1173

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

How to delete duplicate rows from table except one?

1039

What are ddl (data definition language) statements for tables in ms sql server?

1148

What are wait types?

1197

What are orphan records?

984

Where actually sql azure database is hosted?

165

What are the types of resultset?

1011