Answer Posted / rajiv singh

Truncate deletes all rows from table. But Delete deletes
row/rows by condition.

What is the log shipping?

584

---

What is stretch database in sql server?

568

---

What are the different types of replication you can set up in sql server?

529

---

What do you mean by an execution plan? How would you view it?

493

---

How do we know if any query is retrieving a large amount of data or very little data?

552

---

---

Does windows server 2016 come with sql server?

501

---

How to call stored procedure using http soap?

520

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

510

---

Define inner join in sql server joins?

535

---

Explain magic tables in sql server?

551

---

what is a correlated sub-query? : Sql server database administration

482

---

Do you know what is difference between stored procedure and user defined function?

614

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

503

---

What are the new scripting capabilities of ssms? : sql server management studio

556

---

Explain what is the function of sql server agent windows service?

544

---