Answer Posted / atul patil

Fllform of 'XP' is extended procedure
......................Atul

Explain the benefits of user-defined functions?

530

---

How the authentication mode can be changed?

610

---

What are the types of user defined functions in sql server?

505

---

What is the cpu pressure?

565

---

What is sql collation?

655

---

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

117

---

What do you mean by acid?

580

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

624

---

what is an index? : Sql server database administration

525

---

What do you do in data exploration

568

---

What is nonclustered index on computed columns?

573

---

List down some advantages of sql stored procedure?

566

---

Does partitioning improve performance?

493

---

Is resultset an interface?

560

---

How to reaname table name without using sp_Rename in sql server..?

530

---