In this post I cover a fairly common VM CPU configuration mistake that may end up hurting your SQL Server’s performance and wasting licensing money. Intro It’s not uncommon that …
performance
-
-
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, …
-
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 …
-
This is a really short post covering the cause and fix for slow/poor VirtualBox VM performance on Windows hosts. So in one of my previous posts I’ve enabled a Windows …
-
In this post I cover a script I’ve put together for measuring storage write speeds in SQL Server, namely against database data files. This is meant to help get an …
-
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 in SQL Server as well as some myths about best practices when it comes to SELECT COUNT. SELECT COUNT …
-
I’ve been looking in the past couple of weeks for posts testing large insert speeds in SQL Server between different scenarios, and was unable to find anything more recent that …
-
PSBlitz is a PowerShell script that outputs SQL Server health and performance diagnostics data to Excel and saves execution plans and deadlock graphs as .sqlplan and .xdl files. Introduction Since …