What are .mdf files?

0 Answers  

---

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

0 Answers  

---

What is a synonym for manipulation?

0 Answers  

---

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 trigger . hw will it use them

2 Answers   TCS,

---

---

How you can find out if an index is useful to the optimizer?

0 Answers  

---

What is local temp table?

0 Answers  

---

What are the features of Embedded SQL

0 Answers   HCL,

---

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

What is a self join in sql server?

0 Answers  

---

Explain the architecture of ms sql reporting service?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---