Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 0 Answers
- 2879 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How to list all stored procedures in the current database using ms sql server?
what is package and it uses and how can u call a package
What is enhanced database mirroring in sql server 2008?
One table how may column and Primary key
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````
How to add an address record into adventureworkslt?
How do I delete a sql server database?
What is an indexing technique?
How to create a simple user defined function in ms sql server?
Explain following error properties?
What method is used by the Command classes to execute SQL statements that return single values?
Diffrences between sql server 2000 vs 2005
-
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)
