Answer Posted / Roshi Gupta

{"windows command prompt": "To find the list of fixed drives and their available space in Windows, open the Command Prompt and run the following command: wmic logicaldisk get caption, freespace".}

How can I check that whether automatic statistic update is enabled or not?

1108

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1184

---

How to remove duplicate rows from table except one?

1077

---

What is the difference between upgrade and migration in sql server?

1170

---

What is subquery? Explain the properties of a subquery?

1054

---

Can sql servers link to other servers like oracle?

907

---

What is self contained sub query?

1138

---

How to enter binary string literals in ms sql server?

1235

---

Why should you use or avoid select * statements?

1103

---

Can we do dml on views?

1029

---

When should you use an instead of trigger?

1042

---

What are different types of constraints?

995

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

---

What is a coalesce function?

1275

---

do you know how to configure db2 side of the application? : Sql server database administration

1114

---