A small, practical trick: use a local AI agent to find the code that generates a SQL query.

In this post, we'll investigate how Scalar User Defined Functions affect SQL Server performance and explore solutions to mitigate these issues.

With this article you will find out how to correctly measure and compare SQL queries performance with IO STATISTICS.

Incorrect ORM mapping can lead to significant performance issues, which can be difficult to diagnose and fix. One of the common problems related to mapping is the implicit conversion problem, which we'll focus on in this post. This issue can lead to scanning the entire table, we'll explore how to fix this by enforcing correct column mapping.

Stack overflow exception from LINQ deferred execution.