Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.
SQL Server Performance Tuning Real-World Scenarios – Training Day at #SQLBits 2020
I am very excited to present my day long (pre-con) known as Training Day at SQLBits. SQL Server Performance Tuning Real-World Scenarios.
SQL SERVER – Sample Long-Running Query for Demonstrations
Today we will talk about a sample long-running query which I use for my demonstrations. I travel across the world presenting on SQL Server.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
SQL SERVER – An Index Reduces Performance of SELECT Queries
SELECT Queries can slow down even when an index is absent from the final plan. See how compilation, statistics and controlled tests explain why.
Logistic Step 1: Connecting Via SQL Slack for Server Performance Tuning Practical Workshop for EVERYONE
My SQL Server Performance Tuning Practical Workshop for EVERYONE is very interactive, and we use Slack for that part. Here is how to connect before the class.
14 Days to #SQL Server Performance Tuning Practical Workshop for EVERYONE
Only 14 days left to my SQL Server Performance Tuning Practical Workshop for EVERYONE. Due to high demand, I just opened 5 more seats to learn my business secrets.