Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

How to filter records of table in SQL SERVER?

0 Answers   Petranics Solutions,

---

What is raiseerror? What is raiseerror?

0 Answers  

---

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

what is a mixed extent? : Sql server administration

0 Answers  

---

How to modify an existing stored procedure in ms sql server?

0 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

What are different backups available in sql server?

0 Answers  

---

Explain log shipping?

0 Answers  

---

What is the difference between online clustering and Offline clustering?

0 Answers   IBM,

---