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 are the type of joins? When do we use Outer and Self joins?

3 Answers  

How do I setup a sql server database?

0 Answers  

Normalization and denormalization

3 Answers   Wipro,

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

0 Answers  

What is The Use Of TIMESTAMP DataType in SQL Server 2005?

6 Answers  

What are explicit and implicit transactions?

4 Answers   BirlaSoft,

What guidelines should be followed to help minimize deadlocks?

0 Answers  

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

0 Answers  

How to see existing views in ms sql server?

0 Answers  

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

For more SQL Server Interview Questions Click Here
Categories