Answer Posted / rajendra prasad reddy penumall

select salary=max(salart)from from EmpMaster

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

948

---

What is transaction server explicit transaction?

1029

---

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1066

---

List the advantages of using stored procedures?

1056

---

How to select true false based on column value in sql server?

1034

---

Explain what are magic tables in sql server?

998

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2225

---

Define indexes?

1045

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1054

---

How retrieve field names from the table in SQL through JAVA code?

1910

---

What is 1nf normalization form?

1035

---

What is the purpose of floor function?

1039

---

Where are sql server usernames and passwords stored in the sql server?

1116

---

What is ms sql server reporting services?

1056

---

Explain the different index configurations a table can have?

947

---