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
- 7951 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 is 2nf in normalization?
Which is the latest version of sql server and when it is released?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
when you create a database how is it stored? : Sql server database administration
How to create new table with "create table" statements?
How to insert new line characters into strings?
What are the benefits of normalization?
What happens if you are trying to access a schema not owned by you?
Why would you use sql agent?
Does hive support indexing?
Can a database be shrunk to 0 bytes, if not, why?
What is the difference between primary key and unique constraints?
-
Oracle (3253) - 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)
