Answer Posted / srinivasa ganamur

Hi,

In 2000 : Log Shipping require Enterprise Edition.Expensive
hardware.

In 2005 : Log Shipping available in Standard Edition.cheap
hardware.

Regard's
Srinivasa Ganamur

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

1193

---

Can we shrink data file in sql server?

1135

---

What is sql server query analyzer?

1137

---

What is in place upgrade in sql server?

1137

---

What is sql or structured query language?

1236

---

What are wait types?

1262

---

Why we use the openxml clause?

1088

---

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

1210

---

What is a scheduled job or what is a scheduled task?

1044

---

What is a view in sql?

1049

---

What is clustered index

1095

---

What is a coalesce function?

1292

---

How do I find query history in sql server?

1034

---

List out the different types of locks available in sql server?

1058

---

What is the primary use of the model database?

1157

---