Why You Should Care About What You Return in Your ScheduledJob.Execute

Finally get my blog up and running again, welcome

A deep dive into a fatal flaw in Geta-NotFoundHandler that caused high CPU usage due to an endless loop triggered by an empty redirect rule.

Solving the Mystery of High Memory Usage

A memory dump investigation into rising memory usage and the mystery of free objects in the Large Object Heap.

Loading sos.dll to Windbg

AsyncHelper Can Be Considered Harmful

The Search for the Dictionary Key

A deep dive into a performance issue caused by nvarchar(max) misuse in a scheduled indexing job.

As string is the most common data type in an application, nvarchar and its variant varchar are probably the most common column types in your database. (We almost always use nvarchar because nchar is meant for fixed length columns which we don’t have). The difference is that nvarchar has encoding of UTF-16/USC-2 while varchar has UTF-8.