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
- 2933 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can foreign key be deleted?
when we use function instead of procedure? plz tell me the situation with ex?
How the authentication mode can be changed?
What is the contrast amongst drop and truncate?
What are the types of subscriptions in SQL Server replication?
What the difference between UNION and UNIONALL?
What are subqueries in sql server? Explain its properties.
What does the update command do?
How can windows applications connect to sql servers via odbc?
what is a stored procedure and trigger?
What is the recovery model? List the types of recovery model available in sql server?
what are the limitations of parameters in a storedprocedure
-
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)
