You can make your code faster.
With the 7 videos below, you'll learn why the design patterns in your code are not optimized for SQL Server and how it's making your code slow. We'll identify these patterns, then fix it.
In this series you'll learn:
- Temp Tables vs Table Variables
- How CTE’s go WRONG!
- Finding Top Offenders
- SQL Server Sargability
- IF Exists vs COUNT
- SQL Server Benchmarking Queries
- Duplicate and Partial Duplicate Indexes
Let us make your Code Go Fast
Our Tuner have been doing this for over 10 years
Talk to A Tuner Now!
Temp Tables vs Table Variables
Working with a small subset of data, use Table variables. If you’re using large subsets of data Temp tables may be for you. In this video learn to apply indexes or specifying a clustered index.
How CTE’s go WRONG!
When you have small views, they act like a drive tables. It starts to go south when you have a number of CTE’s nested on top of each other. Watch how we optimize for performance
Finding Top Offenders
We walk you through how to use extended event to capture your top offenders.
SQL Server Sargability
Using an index inside a V-tree to find the data you need instead of searching through rows of data
Want training with your code tuning? We love this stuff.
Let us show some imediate value for you!
Schedule a Quick Call
IF Exists vs COUNT
If you need to know how many records exists, consider using a terminating query like IF Exists instead of COUNT to increase performance.
SQL Server Benchmarking Queries
Learn how to benchmark queries in a non production environment for set statistics for IO and CPU time.
SQL Server Duplicate and Partial Duplicate Indexes
One of the most common mistakes I see by accidental DBA’s and DBA’s alike make is focusing on a query and implementing new indexes to just improve one query. Especially, when you already have indexes that could help you with some minor or no changes required.