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 fast. Introduction …
Category:
Performance
-
- PerformanceSQL Server
How applications cause excessive ASYNC_NETWORK_IO waits in SQL Server
by Vlad DrumeaIn this post I’ll go over what the ASYNC_NETWORK_IO wait type is, when it occurs, and how you can tell if the application is causing it. Lately I’ve had to …
-
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 …