My latest article on SQLPerformance.com was published today and highlights the potential for performance problems while using the hot-add vCPU feature in ESX 5+ with wide VMs for SQL Server.
This is a potentially hidden problem with serious performance implications that should be checked for if you are using VMware to run wide VMs with greater than 8 vCPUs on NUMA hardware.
The introduction of DATABASE SCOPED CONFIGURATIONS in SQL Server 2016 enabled different configuration settings at the individual database level. However, there is no logging of
While I was doing some research for a client on how to accomplish a specific task, I happened across a BOL topic that caught my
This is a topic that comes up a lot for us as consultants and I realized recently that I have never blogged about it. Usually
This post is a follow up to my previous post on the performance impacts of the AT TIME ZONE implementation in SQL Server based on
This only demonstrates that the performance impact is the result of AT TIME ZONE. To see how to work across date ranges read my follow
I feel like I have had this discussion multiple times over the last few months with clients, so I decided to turn those discussions into
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.