Answer Posted / thrilok

Migration is the process of taking the backup and restore into the target server (One or More).
Down time is not mandatory.
Man power is required.

Upgradation is the process of replacing the old version of sql server with the new version of sql server.
Down time is mandatory for upgradation.
Man power is not required.

Can you always create a cache of a report?

174

---

What is a non equi join?

987

---

What are truncate options available in sql server? : sql server database administration

1037

---

Is t sql the same as sql server?

988

---

What is ems sql management studio? : sql server management studio

1116

---

Can binary strings be used in arithmetical operations?

942

---

What is the recovery model? List the types of recovery model available in sql server?

906

---

How many types of built in functions are there in sql server 2012?

928

---

What is subquery in sql?

1074

---

When is the use of update_statistics command?

1015

---

What is use of except clause?

1095

---

What is difference between cte and view?

924

---

What are the different types of sub-queries?

1048

---

Do you know what are pages and extents? : SQL Server Architecture

999

---

What is meant by Active-Passive and Active-Active clustering setup?

1185

---