hi,
the following are the outputs of sp_spaceused and
sp_tempdbspace
sp_spaceused
------------
database size unallocated size
tempdb 77752.95 MB 28026.99 MB
sp_tempdbspace
-------------
database size spaceused
tempdb 77752.945312 1.007812
the unused space in sp_spaceused is nearly 28 Gb and in
sp_tempdbspace is nearly 76 Gb
cany any one explain about this output and why its giving
different results.
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is analysis service repository?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is cube dimension? : sql server analysis services, ssas
What are the types of database schema? : sql server analysis services, ssas
What are the different types of sql server replication? : sql server replication
What are the differences between stored procedure and the dynamic sql?
When to use Inner join & when to use subquery?
What happens if time-only values are provided as date and time literals?
What is the difference between ‘having’ clause and a ‘where’ clause?
What have included columns when we talk about sql server indexing?
Explain the properties of the relational tables?
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?