Answer Posted / raji

Different Types Of JOINS:
Most of the joins you will come across are based on
equality, with the equijoin being the most dominant.
In this chapter you learned about equijoins; there are
other types of joins you must become familiar with, most
notably the self-join, the nonequijoin, and the outer join.

Equijoin or Inner Join (Equality) : Traditional comma-
separated join or ANSI JOIN syntax (including optional
INNER keyword).
Natural Join (Equality) : NATURAL JOIN keyword.
Cross-Join or Cartesian Product (No join condition):
Traditional comma-separated with the missing join condition
in the WHERE clause or CROSS JOIN keyword.
Self-Join (Equality): Equijoin or Inner Join.
Outer Join (left, right, full):(Equality and extending the
result set): "Complex Joins" OUTER JOIN keywords or outer
join operator(+).
Non-Equijoin (Nonequality of values): "Complex Joins"
Traditional comma-separated join or ANSI join syntax with
the ON clause.
The join criteria is not based on equality.

Ways to improve the performance of a SQL Azure Database?

125

---

Explain where clause?

990

---

What do you understand by recursive stored procedure?

930

---

How do I setup a sql server database?

1077

---

Does partitioning improve performance sql server?

983

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

---

What is data source in connection string?

910

---

How is SQL Azure different than SQL server?

225

---

What are the requirements on sql server network connections?

1000

---

List the advantages of using stored procedures?

1056

---

Define full outer join?

960

---

What are the tools available in market as an alternative to sql server reporting services?

131

---

Explain the creation and execution of a user-defined function in the sql server?

1051

---

Can you explain important index characteristics?

993

---

What are different types of schemas?

947

---