Answer Posted / krishna sandeep

Advantage:

you can do row vise validation from a table

Disadvantage:

of example you are retrieving 100 row...
every single row you retrieve will hit the server as a
single select query so performance will be low.

What is standby servers? Explain types of standby servers.

1058

---

What is row_number () and partition by in sql server?

1138

---

What is the difference between functions and stored procedures?

1226

---

What is normalization and denormalization in sql server?

1065

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115

---

How to concatenate two strings in SQL Server.

1208

---

Define Business Edition in SQL Azure?

102

---

What is trigger in salesforce?

1055

---

What does man by sql wildcard characters in sql server?

1106

---

what is the different types of backups available in sql server? : Sql server database administration

974

---

How to count duplicated values in a column in ms sql server?

1171

---

Explain atomicity?

1130

---

what are cursors? : Sql server database administration

1106

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2085

---

What are the types of containers in ssis?

1235

---