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
- 7757 Views
- Cognizant, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What do you understand by a view? What does the with check option clause for a view do?
how to trace the traffic hitting a sql server? : Sql server database administration
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What stored by the model? : sql server database administration
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is the difference between Normalization and De-normalization?
What are the 7 disadvantages to a manual system?
How to edit table in sql server 2017?
What is equi join with example?
How data can be copied from one table to another table?
What is 3nf normalization form?
Why do we use stored procedures in sql server?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
