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.

0 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

How to disable stored procedure sql server?

0 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

List out the difference between union and union all in sql server?

0 Answers  

---

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

0 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

0 Answers  

---

How do I start sql server 2016?

0 Answers  

---

What is conditional split?

0 Answers  

---

What is the query optimization statistics?

1 Answers  

---