Answer / Surendra Nath

The difference in results between sp_spaceused and sp_tempdbspace is due to the way these stored procedures report the allocated and unallocated space for the tempdb database. sp_spaceused provides a high-level overview of the total size, used space, and available space for all databases on the instance, whereas sp_tempdbspace focuses specifically on the tempdb database. The unused space in sp_spaceused is nearly 28 GB, while the unused space reported by sp_tempdbspace is nearly 76 GB, but this discrepancy is likely due to the different methods used for reporting and not actual lost space.

Does any body please help me what question's have asked for SSRS in the interview?

1 Answers  

---

what is index seek and index scan?

2 Answers  

---

About DTS usage ?

2 Answers   Cognizant, Wipro,

---

What is difference between drop truncate and delete?

1 Answers  

---

Write a program using SQL queries to find a unique entry in a table.

1 Answers   Tech Mahindra,

---

Where is localdb stored?

1 Answers  

---

What are the advantages of partitioning?

1 Answers  

---

What is the difference between varchar and varchar(max) datatypes?

1 Answers  

---

How to see existing views in ms sql server?

1 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

1 Answers  

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---