Answer Posted / sannnnnnnnnnn

select max(sal) from emp where sal<(select max(sal) from emp)

What are the types of subscriptions in SQL Server replication?

1040

---

Can I disable or restrict ssrs export formats (rendering formats)?

150

---

Explain differentiate between a having clause and a where clause?

913

---

What is a periodical index?

928

---

What is the command dbcc checkdb used for?

1010

---

Explain what you mean by 3 tier architecture.

1077

---

How to see the event list of an existing trigger using sys.trigger_events?

1075

---

What is the maximum size of sql server database?

1011

---

Do you know what is sql service broker?

1088

---

What is filter index?

951

---

What is a non equi join?

981

---

How to list all columns in a table using odbc_columns()?

976

---

What are the advantages of having an index on the sql server?

925

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1063

---

when would you go for denormalization? : Sql server database administration

871

---