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
- 2990 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
How to write stored procedure to update the data in 10 tables
What are a scheduled jobs?
What is row-level compre?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What are trace files?
What do you understand by sql server agent?
What is the tcp/ip port on which sql server runs?
how many type of indexing in database?
What are the tables in sql?
How to get a list of columns in a view using "sys.columns" in ms sql server?
Relational calculus is what type of language?
-
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)
