What do you understand by hotfixes and patches in sql server?

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

How many triggers are possible per table?

0 Answers  

---

What command is used to delete a table from the database in the sql server and how?

0 Answers  

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

---

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

0 Answers  

---

Why is normalisation important?

0 Answers  

---

Tell me extended events in sql server 2008?

0 Answers  

---

Explain different isolation levels?

4 Answers  

---

What is sql service broker?

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,

---

How to update multiple rows with one update statement in ms sql server?

0 Answers  

---