6 Query Tuning Techniques - Solve 75% SQL Server Performance Problems (by Amit Bansal)

Great video. Keep doing these. I would love to see how you simulate a situation where tempdb is full and a query is still running

Thank you it's new to learn

Excellent explanation

I want to join performance tuning class? Can any body pls help me?

this is a good example

It was clear and concise explanation. I understood it completely. Thanks for this video.

Really nice explanation on Tunning SQL by Amit

You are just Amazing ...!!! Kudossssssssssss

Sir for recompile, I have a question
At the same time procedure run if another request comes at that time what will happen?
Is error occurred?

excellent explanation, great contribution, thank you!

Thanks 🙏

Excellent explanation Keep it up!!

Another hidden performance trick is to be careful about using NVARCHAR and VARCHAR interchangeably. I've had instances where query performance was improved by over 80% by simply casting nvarchars to varchar or varchar to nvarchar in the underlying data or subqueries. More often than not, converting early and staying consistent with data types can improve performance. Don't discount the cost of casting between types.

In the second case: if you are looking for first name "ken" with the index last name+first name+middle name what would be the solution without creating a new index to be a seek and not scan?

Thank you for this very useful video!

It was awesome

DPS was a life and career changing event for me and helped me to leap towards my great career journey as a SQL Developer. DPS indeed instilled me the confidence that I could also become a SQLMaestros with a different work experience altogether. Your videos are all worth watching, and missed attending those live sessions. Hope to join those sessions personally soon !
You are amazing and please continue the great work and continue to transform our lives ! May God continue to bless you and your upcoming sessions.

Super session. Great thanks.

amazing tips

Very good content. Exceptional way to explain topic

hi

video is really helpful.but need a guidance , i came across a bug in sql query , which returns incorrect records 1 in 1000 records. how to tackle such issues, request you please make a video of such scenarios.

thanks for useful information.....keep post about sql server

This is very helpful. Thanks a lot!

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

Really appreciate your contents which is quite Informative. Keep up the good work in future also. Thanks Buddy.

very helpful SQLMaestros, Thanks again

Thanks

any idea on how to tune table where column need like '%%'

Great information thank you

In the first example why didn’t you just remove the conversion and put the modified date in the same format as your solution ‘yyyy/mm/DD’?

Great video Amit. However, Pinal Deve says index has nothing to do with performance, index is the culprit, delete the indexes if you want to improve performance. Now, I'm confused, two SMEs say two different things. Correct me if I'm wrong

Awesome very clearly explained

Very helpful!

specifically liked the implicit/explicit conversions improving performance

Sir it's really nice explanation 👌

Very toot content very very helpful
Thanks sir

Nice sir very helpful for me 👍

Very useful! Thanks for the video

Amit, this is great... Time to build out a zero to hero course :-).... Id help and Id take it after haha. Thank you sir.

Very informative. Thank you very much!

This course is brilliant. Thank you sir very much. Greetings from germany

good job :)

Can you please explain how to use query store with example this very helpful to everyone

Excellent

Hi Amit, Great Explanation... But i couldn't understand why you change the Business Logic to make SQL Server Faster.? For Example; Take Seek, you change the Business logic to show us what makes scan and seek, good till that... But how to make the Scan converted to Seek without changing the Business Logic.?

Lots of useful content but skipped first 10 minutes or so...