The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved into cloud services, their efficiency has a direct impact on the recurring bills. A workload that consumes more resources than necessary costs more to host in the cloud and affects the bottom line for your organization.
2023-04-07
7,887 reads
Previously we covered Part 1: Indexing for the WHERE Clause, and then we covered ORDER BY. Today, let’s tackle joins.
2020-03-20
I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class. To make that easier, I’m running the Fundamentals of Index Tuning class this week on the blog.
2020-03-13
I’m teaching my Mastering Index Tuning pre-con at SQLBits and SQL Saturday Iceland, and part of the prerequisites is that you’re already familiar with my How to Think Like the Engine class and my Fundamentals of Index Tuning class.
2020-03-12
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Script to identify the most expensive queries on your database server using the Query...
In this post we're going to go through the steps to set up Always...
I'm looking for best practice here and these are Azure VMs by the way....
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Comments posted to this topic are about the item Build a Better WordPress Archives...
Ask SSC