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
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.