In this post I cover ways to fix performance problems caused by implicit conversion when the query cannot be modified. What is an implicit conversion? I’ve already covered, in detail, …
Category:
Performance
-
-
In this post I show a few examples of implicit conversions in SQL Server and the impact they can have on query performance. Types of conversions in SQL Server If …
-
In this post I cover my solution to Brent Ozar’s recent query exercise, where we needed to optimize a query so that it’s able to find long values faster. Introduction …
-
In this post I cover what the ASYNC_NETWORK_IO wait type is, when it occurs, and how applications cause ASYNC_NETWORK_IO waits in SQL Server. Lately I’ve had to troubleshoot a few …
-
In this post I’ll cover ways of speeding up SELECT COUNT as well as some myths about best practices when it comes to SELECT COUNT. SELECT COUNT use cases SELECT …
-
I’ve been looking in the past couple of weeks for posts comparing large insert speeds in SQL Server between different scenarios, and was unable to find anything more recent that …