SQL Basics: Search in nText columns

Anybody ever tried to search in ntext or text fields on MS SQL Server? Common experience is to fail. Solution: cast your search-term to text type, and try again. Example, using EA-Database: SELECT * FROM t_xref x WHERE x.Description LIKE...

Getting your Types

In one of our projects we had a little performance problem, so we researched some stuff to get things faster. Problem: We have a XML File with a List<Base> and we wanted to generate Enterprise Architect Elements out of them. So we needed to check if the Base...