Using SQL/CLR integration

Here is a good example of how you can use .Net language and integrate it into SQL.

e.g. run a piece of c sharp code in a stored procedure

SQL CLR Stored Procedure using Visual Studio 2010

Index on uuid when using NHibernate

Guid is a simple and easy solution for generate random ids.
However, when a table is using uuid as the key, it's not so simple to index base on ids.

Here is a good blog showing how you can create your own id generator that taking advantage of the uuid and give you a result id that can be indexed.

Using guid id in nhibernate, index fragmentation

SQL join basic

In SQL, Join is a powerful and useful operation. It can be used to return data from multiple tables.

There are different types of joins (that I know)

• Inner Join (Default in some DBs): Select only the matched rows from two tables
• Left(Right) Outer Join: select all rows from Left(Right) table and matched rows from the second table
• Cross Join: return all rows from both table. Even there are 'NULL' values in its column

ref: http://en.wikipedia.org/wiki/Join_(SQL)#Natural_join