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?
Answer Posted / allah baksh
exec sp_spaceused [schema.tablename] this will give you
data file and the size available
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is a full-text index updated?
What is unique key constraint?
Why union all is faster than union?
What are types of subqueries?
List types of tables in SQL Azure?
Can group functions be used in the order by clause in ms sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
How do I view a stored procedure in sql server?
What does it mean to normalize a database and why would you do it?
Sql server reporting services vs. Crystal reports.
‘Order by’ is not allowed in a view how can you sort information from a view?
What is the default port for SQL Server over a firewall?
How do I start and stop sql server?
What are the pre-defined functions in the sql server?
Explain sub-query?