Interested to Buy Any Domain ? << Click Here >> for more details...
What is scan table/view and seek table/view when its occurs? : sql server database administration
- 0 Answers
- 1031 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the basic functions for master, msdb, model, tempdb databases?
What are binary string data types in ms sql server?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
default databases available in sql server and there uses ?
Can you explain various data region available in ssrs with their use?
What are the differences between lost updates and uncommitted dependencies?
What is entity data services?
What should we do to copy the tables, schema and views from one SQL Server to another?
How to create indexed view?
can you any body tell me the difference between candidate key and primary key
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
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.
-
Oracle (3259) - 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)
