It will be good if you also share the query in the Description or on your blog/website so we can directly copy from there. Or else no use of watching the video
you show how to find long running queries, but how does one fix it in sql server management studio ? because we will not have access to source code of programs like QuickBooks.
I have implemented Table Partitioning in Azure Sql Server and my table is working fine but sometimes It takes time to retrieve data like in 1 min it retrieves more than 1 lakh records and sometimes i get only 15000 .Please help me on this