Recently I wrote about how to look into, identify and solve the problem with a SQL Server execution plan – as you can read here: http://vimvq1987.com/2017/10/curious-case-sql-execution-plan/ I have some more time to revisit the query now, and I...

I said this, and I will repeat it here: SQL Server optimizer is smart, and in most of the cases, it’s smarter than you and me (I have no doubt that you are smart, even very, very smart 🙂 ). So most of the case, you leave it to do whatever it thin...

ServiceAPI has been a popular RESTful APIs for Episerver Commerce, and it has been used by many websites, allowing easy and reliable integration with external systems. However up until now, only Catalog-related APIs (and a small set of CMS asset a...

Recently I worked on a support case where a customer reported deadlocks and timeout exceptions on queries to a specific table – NodeEntryRelation. Yes, it was mentioned in this post. However, there is more to it. Keeping the indexes healthy...

Recently I stumped upon this question: http://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2017/8/event-for-price-becoming-validinvalid/ which is very interesting to me. I can see this is a real scenario – and even...