Answer Posted / bed singh

1. We can do row vise validation but performance is
slow.
2. Each time we fetch a row from the cursor, it result
a network round trip, where as a normal select statement
query make only one round trip.
3. If the ResultSet is less than 50 or 100 records it
is better to go for implicit cursors. If the result set is
large then you should use explicit cursors. Otherwise it
will put Burdon on CPU.

What are trace flags and mention a few common trace flags used with sql server?

1141

---

How do I view a trc file?

978

---

How many categories of data types used by sql server?

1055

---

What are different types of data sources?

1085

---

What is sql injection? How to protect against sql injection attack?

1043

---

Explain indexed views?

1031

---

What is report rendering ?

162

---

what do you understand by change data capture?

1080

---

How to modify existing triggers using "alter trigger"?

1068

---

What is the recursive stored procedure in sql server?

1081

---

What is inline table-value user-defined function?

1165

---

How many cores do I need for sql server 2016?

953

---

Explain the different types of joins?

1046

---

Explain about protocol layer present in SQL server?

1296

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1230

---