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

The bundled content focuses on internals, troubleshooting, query tuning, performance optimization, tips, tricks, and loads of content from the real world.

[rohitsakalle]

Very nice content....8:10 Non Sargability, 2nd Not using Index 18:40 Implicit Conversion 29:30 DPS 38:00, Bookmark lookup 56:00, Parameter sniffing 1:12:11 (Community service ;-D)

[pralaysangma]

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 Amit and please continue the great work and continue to transform our lives ! May God continue to bless you and your upcoming sessions.

[sdbjakeer]

Very nice. I've got answers for many of my questions..

[gozinto]

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

[alianwar]

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

[alangrichmond-szct]

VERY clear and excellent explanation i use all the queries on my ssms and it worked correctly thanks very much from Texas USA

[mrunalahire]

Really informative with all possibilities

[Sreedevi]

Very detailed explanation in a very simple way.

[CalvinPuah]

Very informative. Thank you very much!

[PepeFuego]

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

[abhaysingh]

Very very Very informative. Thanks a lot. Keep posting some ticks and tips also as a short videos.

[rohit]

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

[udayakoju]

Very useful information, thanks for sharing the video

[juancarlosvasquezgarcia]

excellent explanation, great contribution, thank you!

[dhanashrikarale]

Very nice looking for this from long time

[TellaTrix]

Really nice explanation on Tunning SQL by Amit

[khalilkazi]

Very good content. Exceptional way to explain topic

[SuperWhatusername]

very helpful SQLMaestros, Thanks again

[bwzffgh]

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.

[cwtrain]

"Not *your* performance problems, your *SQL Server* performance problems."

Bruh. Why you gotta do me like that? Hehe. Cheers. These videos are excellent.