Query Performance

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.

This post will examine the consequences of retrieving all columns from a table and explore best practices for data retrieval using NHibernate.