30 Seconds to 4 Seconds - A Real SQL Server Case Study
Database Star
???? Get the AI prompt from this video: https://databasestar.mykajabi.com/lpkj-ai-sqlserver/?video=QybD_ybyyyI
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/VxZmEozw/checkout?video=QybD_ybyyyI
In this video, we look at a slow query in SQL Server and make a series of changes to try to get it to run faster. Then I ask an AI tool to analyse the query to see what improvements it suggests.
TIMESTAMPS
00:00 - Our query
03:35 - Improve the filter
04:19 - A structural change
06:44 - Move calculations
10:13 - Add indexes
12:29 - AI analysis
???? Get 56 bad query patterns & fixes: https://databasestar.mykajabi.com/offers/VxZmEozw/checkout?video=QybD_ybyyyI
In this video, we look at a slow query in SQL Server and make a series of changes to try to get it to run faster. Then I ask an AI tool to analyse the query to see what improvements it suggests.
TIMESTAMPS
00:00 - Our query
03:35 - Improve the filter
04:19 - A structural change
06:44 - Move calculations
10:13 - Add indexes
12:29 - AI analysis
0 Comments
No comments yet. Be the first to weigh in.