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
- 7739 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
How can you append an identity column to a temporary table?
Explain indexing and what are the advantages of it?
What do I need to start working with sql studio? : sql server management studio
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
Tell me what is fill factor?
What is the log shipping?
What part does database design plays a role in performance of an sql server-based application?
what are the different stages of Report Processing?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
How much is a sql server license?
What is the purpose of sql profiler in sql server?
What is cross join in sql server joins?
Explain acid?
Can an entity have two primary keys?
Explain transaction server implicit?
