Earlier this year I made a series of videos that were played before the start of several DBA Fundamentals presentations. These videos gave viewers something SQL related to watch while the online rooms were filling up with attendees before the start of each day's live presentation.
Since these videos only ran once, and because my regular filming location is under construction this week, I decided to republish them here today.
Hope you enjoy these quick tips on several SQL Server concepts.
STATISTICS IO, TIME
Enabling STATISTICS IO and TIME can help you benchmark your queries to see if your tuning efforts are helping or hindering execution performance:
Key Concepts
The terminology surrounding keys in relational databases can be confusing - in this overview we summarize the difference between primary keys, foreign keys, natural keys, and more:
SARGability
When performance tuning queries, one of first things to check is whether your queries are SARGable and allow the optimizer to seek to the data it needs: