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 is raid, and how it can influence database performance?

0 Answers  

---

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

0 Answers  

---

What is the maximum size of a row in sql server?

0 Answers  

---

Alternative way to DetDate() function?

5 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers  

---

What is merge join?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What are the different types of stored procedures?

0 Answers  

---