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 transaction server implicit?

1015

---

Where cross join is used?

968

---

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1026

---

Ms sql server index?

1068

---

Explain how would you store your query in an SSRS report or a Database server?

128

---

Do you know data definition language, data control language and data manipulation language?

1043

---

What is merge?

1021

---

How do we synchronize On-Premise SQL server with SQL Azure?

122

---

What is data block and how to define data block size?

1029

---

What is failover clustering overview?

1091

---

What are two difference between sql azure and azure tables?

159

---

What is a partition key?

957

---

List the different index configurations possible for a table?

934

---

What is sql server locking?

996

---

What is the sql server 2000 version number?

1083

---