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.
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
Back in 2012, I wrote a post titled Looking at External Disk Performance using USB 3.0 and eSATA with SSD, where I tested a number
It happens to the best of us and this post is more of a reminder for myself the next time it happens to me than
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.