Great detailed explanation, from concepts to even Power BI.

Thanks for this, it's something I use daily, so really useful.

I use CTEs to do updates and deletes against a table.

{

with cte as (

select id, field2change from table

where id = '1234'

)

update cte

set field2change = '4321'

}

This way with the cte you...

Great saga of articles, but I'm anxiously waiting for the fix part in next chapter

Hi Luis,

If possible a sequel of this article could be a performance comparison between LIKE and PATINDEX, and maybe also include CONTAINS.

...

I copied the following from a Blog

http://sqlperformance.com/2012/07/t-sql-queries/split-strings

The most recommended is CLR, which is to create a dll in C# and call it...