After 4 years, I recently came across this video Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar). It has been incredibly helpful in resolving some long-standing issues I've been facing. I want to express my sincere gratitude for such a wonderful session with detailed explanations. Thank you so much - you’re truly the best in what you do.
Actually he did mention that avoiding the sort would solve the problem but if you must have the sort then the solution will be to insert the data from the select statement into a temp table then the sort of that temp table will have accurate statistics and will be super fast.
After 4 years, I recently came across this video Part 1 - How to Troubleshoot a Slow Running Query in SQL Server by Amit Bansal (Recorded Webinar). It has been incredibly helpful in resolving some long-standing issues I've been facing. I want to express my sincere gratitude for such a wonderful session with detailed explanations. Thank you so much - you’re truly the best in what you do.
very helpful, thanks a lot.do you have more performance tuning videos
Here, you ran the procedure, but how as a dba I would find which are the procedures and sqls are causing the slowness in the background?
SQL server 2022 working good but internet start to SQL server working is very slow... please any solution
Very nice I really like it
Sir can you suggest how to tune the update statement, if it's running slow.
Make sure the tables involved are not over indexed. Make sure you have the right index to accommodate the predicates in your update statement.
Haha,, He had shown how to check wait info, He did not show solution for slow running queries...
Actually he did mention that avoiding the sort would solve the problem but if you must have the sort then the solution will be to insert the data from the select statement into a temp table then the sort of that temp table will have accurate statistics and will be super fast.
G8 Session...)
he didn't give the solution...hahaha...time waste video