Answer Posted / pavan

lot of differences:
1. mirroring
2. transactional with updatable subscription
3. resource database
4. serialization

Can we perform backup restore operation on tempdb? : sql server database administration

594

---

Which command is used for user defined error messages?

573

---

What is server-level principal?

102

---

What is the main difference between ‘between’ and ‘in’ condition operators?

599

---

What are subqueries in sql server? Explain its properties.

557

---

---

How to write a query with a left outer join in ms sql server?

585

---

What are subquery and its properties?

585

---

What is the purpose of optimization?

556

---

Write a program using SQL queries to find a unique entry in a table.

552

---

How to find out the list schema name and table name for the database?

538

---

How do you make a trace?

593

---

How to get the query of a table in sql server?

509

---

What are the differences between char and nchar in ms sql server?

541

---

How to optimize stored procedure optimization?

530

---

How to receive output values from stored procedures?

490

---