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,

---

What happens if null values are involved in bitwise operations?

0 Answers  

---

How do I know if localdb is running?

0 Answers  

---

What is the importance of a recovery model?

0 Answers  

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

Data table as parameter in sql server?

0 Answers  

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

How fixed length strings are truncated and padded?

0 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

Difference between rowid and rownum in SQL?

1 Answers   Virtusa,

---

How to set database to be single_user in ms sql server?

0 Answers  

---