Answer Posted / amatjeet ray

XP means extended procedure where this procedure is made from dlls files which is written in c++ programing language.

What is transaction server auto commit?

575

---

How to enforce security in sql server? : sql server security

619

---

How we can compare two database data?

519

---

What is dirty read?

624

---

How network traffic be reduced by using the stored procedure?

580

---

---

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

519

---

Can you move the resources after pausing the node? : sql server database administration

594

---

What are the transaction properties?

547

---

Does partitioning improve performance sql server?

485

---

Does the unique constraint create an index?

564

---

Define outer join in sql server joins?

523

---

Which is faster statement or preparedstatement?

526

---

How to stop log file growing too big?

573

---

What types of Joins are possible with Sql Server?

541

---

How to create a ddl trigger using "create trigger" statements?

610

---