Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

explain how to create a new schema in a database? : Sql server database administration

586

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

577

---

What is identity?

563

---

Explain the types of indexes.

649

---

Detail about the hardware which is supported by SQL server?

596

---

---

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

503

---

New concepts of sql server 2005 use in your project.

1919

---

What is the default schema of your login session in ms sql server?

598

---

What do you understand by intent locks?

581

---

what are the three command line utilities and what are their primary functions?

103

---

Do you know what is sql injection?

554

---

Does full backup break log chain?

554

---

What do you mean by an execution plan?

576

---

What is the log shipping?

592

---

How to loop through the result set with @@fetch_status?

675

---