In a previous post I described a technique to insert query hints into NHibernate query with the use of comments. Testing this code in a real project lead to a strange exception when I issue queries with ICriteria The query should start with ‘SELECT’ or ‘SELECT DISTINCT’ This happens because ICriteria queries inserts comments inside [...]
When you work with Big databases with many records and not uniform distribution of data into columns used for join or where conditions, you can have really bad performance problem due to Query Plan caching. I do not want to give a deep explanation of this problem, you can find information here, but I want [...]
Continue reading about Use Sql Server Query Hints with NHibernate HQL and ICriteria
Entity Framework is quite a good product, but in my opinion still misses some point to be called an ORM. I must admit that I never used the 4.1 Code first in real project, but there are some stuff that still does not convince me when using EF. When I decide to use EF (and [...]
I have a domain where one of the business operation consists of analysis of some entities, for each entity we need to do complex analysis involving external servers and until now we could live with a single server that sequentially analyze those entities one after another. All works good, but we reach a point where [...]
Continue reading about EntityLock, implement a logic locking strategy in my domain
I have an entity that has a large Unicode string property actually persisted on a nvarchar(max) Sql server column type. After some months we verified that this column is consuming big amount of database space. Sql server enterprise supports data compression, but this software runs on a Sql Server standard, so we need some strategy [...]
Continue reading about Compress data in sql server 2008 standard thanks to FILESTREAM and NHibernate
