Use Sql Server Query Hints with NHibernate HQL and ICriteria

Sometimes you got bad performance from SQL query due to caching of execution plan, in this article I outline the problem and show you how you can add query hints to nhibernate HQL and ICriteria Query.