Answer Posted / rajan

full form is xp is eXperience and it is 100% right

Do you know what is replace and stuff function in sql server?

469

---

What happens if we shrink log file in sql server?

519

---

Explain the purpose of indexes?

546

---

What is Sqlpaging in SqlServer 2005 ?

662

---

What is a trigger? Why we need it?

533

---

---

What is the difference between varchar and nvarchar?

526

---

How to connect sql server management studio express to sql server 2005 express?

586

---

How can sql server instances be hidden? : sql server security

599

---

What is t-sql script to take database offline – take database online.

602

---

What is the syntax to execute the sys.dm_db_missing_index_details?

586

---

How to query multiple tables jointly?

560

---

What does it mean if @@cursor_row returns a negative number?

575

---

What are the dmvs?

572

---

What is sql server profiler trace data file?

589

---

How to create a local temporary stored procedure?

501

---