Answer Posted / er.harsimran sidhu,rajpura tow

XP stands eXtreme Professional guys

What are the operating modes in which database mirroring runs?

1089

---

How to find the source of a table in sql server?

998

---

What command would you use to add a column to a table in sql server?

1310

---

How to add an address record into adventureworkslt?

986

---

What method is used by the Command classes to execute SQL statements that return single values?

1071

---

How to find related tables in sql server?

947

---

How to update values in a table with update statements in ms sql server?

1013

---

Describe in brief sql server monitoring ways.

1052

---

What is compression - row-level and page-level compression?

918

---

Define union, union all, minus, intersect?

980

---

How much does sql server 2016 cost?

1074

---

Characterize join and name diverse sorts of joins?

968

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1933

---

What are the differences between ms sql server & oracle?

1063

---

What is an etl file?

957

---