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

Data table as parameter in sql server?

0 Answers  

What are different types of schemas?

0 Answers  

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

Tell me what do you understand by a view? What does the with check option clause for a view do?

0 Answers  

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

Do you know what are acid properties of transaction?

0 Answers  

What are logical/boolean operations in ms sql server?

0 Answers  

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

List the different types of collation sensitivities in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories