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
9,460 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
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
You can find the slides for my session at Future Data Driven summit at...
I have a database on SQL 2019 in an Availability Group (AG) and I...
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Hello, I am trying to split data, looks like there is some special...
Ask SSC