Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

1 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  

Explain rdbms?

0 Answers  

Tell me what are cursors and when they are useful?

0 Answers  

How can you start sql server in different modes?

0 Answers  

How can sql server instances be hidden?

0 Answers  

How to set a database state to offline in ms sql server?

0 Answers  

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

Can you explain about buffer cash and log cache in sql server?

0 Answers  

What are types of storage modes? : sql server analysis services, ssas

0 Answers  

What is the basic difference between clustered and a non-clustered index?

9 Answers   Infogain,

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories