Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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.

Question Posted / hari

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

what are file groups?

3 Answers   Evalueserve,

What are the differences between local and global temporary tables?

0 Answers  

How do you simulate a deadlock for testing purposes

1 Answers  

Explain about builtinadministrator?

0 Answers  

What value could be assigned to Varchar Type?

3 Answers  




What is used to replicate sessions between instances in coldfusion clusters?

0 Answers   HCL,

Where do you find the default Index fill factor and how to change it?

0 Answers  

What is postgresql server?

0 Answers  

Does the unique constraint create an index?

0 Answers  

How do I determine how many instances of sql server are installed on a computer?

0 Answers  

What is Schema? and why we use schemas?

4 Answers  

What is resultset concur_updatable?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories