Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 7847 Views
- Cognizant, I also Faced
- E-Mail Answers
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
Explain syntax for viewing trigger?
How to apply filtering criteria at group level with the having clause in ms sql server?
what is the different types of backups available in sql server? : Sql server database administration
Do you know what is rank function?
Explain sub-query?
How to add code to the existing article (using improve article)?
What is the purpose of the model database?
Will the writetext statement activate a trigger?
What are the main differences between #temp tables and @table variables and which one is preferred?
What is the difference between dropping a database and taking a database offline?
What are “lost updates”?
How to verify the port number of the sql server?
Explain about extended stored procedure?
Write a SQL query in order to merge two different columns into single column?
What is the user of Primary key?
