Answer Posted / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

which table keeps the locking information? : Sql server administration

1010

---

What are the three different part of rdl file explain them?

253

---

How does a profiler work?

870

---

What is the cartesian product of the table?

902

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

881

---

What is the default port for SQL Server over a firewall?

1030

---

How to convert numeric values to integers in ms sql server?

1004

---

What are the advantages of sql azure?

138

---

What is log ldf?

930

---

What is "scheduled jobs" or "scheduled tasks"?

911

---

Explain different types of Normalization.

1729

---

How to defragment indexes with alter index ... Reorganize?

1022

---

Explain transaction server distributed transaction?

918

---

Why normalization is used?

965

---

Which table keeps the locking information?

879

---