Answer Posted / kunal gupta

select top 1 sal from (select top n sal from tbl_master
group by sal order by sal desc)m order by sal

This answer is easiest and 100% tested

A trigger can reference objects outside the current database? State true or false.

559

---

What is 2nf normalization?

544

---

Explain what is the difference between union and union all?

550

---

What is left outer join in sql server joins?

555

---

How to specify the collation for a character data type in ms sql server?

559

---

---

How to add code to the existing article (using improve article)?

598

---

Explain the microsoft sql server delete command?

538

---

How do I clean up sql server transaction log?

574

---

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

584

---

Give an example of SQL injection attack ?

570

---

What is the new security features added in sql server 2014? : sql server security

570

---

how would you improve etl (extract, transform, load) throughput?

550

---

How do you size a resultset?

504

---

What is normalization process?

602

---

Why I can not enter 0.001 second in date and time literals in ms sql server?

543

---