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 create a testing table with test data in ms sql server?

0 Answers  

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

---

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

0 Answers  

---

What is partition in sql server?

0 Answers  

---

Can I delete event logs?

0 Answers  

---

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

---

Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  

---

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

---

How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,

---