Remove Key Lookup - SQL in Sixty Seconds 194

[@Abassman1967]

An oldie but a goodie for sure! You rock!

[@PinalDaveSQLAuthority]

Thank you!

[@Rageshshah]

This one is fantastic and will help a lot to people like me.

[@PinalDaveSQLAuthority]

Thanks.

[@gatlaaravind3178]

Best teacher in the world.. for SQLSERVER fan since 2012 to till date

[@PinalDaveSQLAuthority]

So kind of you

[@khaledberhane5413]

Thank you Pinal, That really helps a lot ;)

[@PinalDaveSQLAuthority]

Glad to hear that!

[@babaIraj1]

You are great person. Funny with lot of information. I learned a lot of tricks in SQL from you. Huge thanks to you. 🙂

[@PinalDaveSQLAuthority]

Happy to hear that!

[@ivanb000]

Interesting as always, thanks.

[@PinalDaveSQLAuthority]

👍

[@PinalDaveSQLAuthority]

👍

[@achilleskocaeli]

Thanks for sharing Pinal 👍

[@PinalDaveSQLAuthority]

You are welcome

[@nikunjkelatkar3282]

Thanks for sharing this knowledge sir 😊

[@PinalDaveSQLAuthority]

Thanks

[@sohailsyed5243]

Hey Dev, can you get a video on what are Logical reads, physical reads, ram and memory and basic steps to see on performance tuning

[@PinalDaveSQLAuthority]

Hi Syd, I have already done that on this channel.

[@mariahalt4603]

This tip is gold

[@PinalDaveSQLAuthority]

Thank you so much

[@a.useronly2266]

Great 👍🏻, Thanks sir

[@PinalDaveSQLAuthority]

So nice of you

[@dhruvghori1604]

Hi Dave, can you please explain or make a video on HASH match and how to remove or optimize it.
Thank you in advance.

[@PinalDaveSQLAuthority]

Not necessarily Hash Match is bad.

[@mysubscription104]

Pinal, your videos are always great, always something to learn, if possible, could you please consider WINDOWS FUNCTIONS in future videos in consideration of perfromance?

[@PinalDaveSQLAuthority]

Good Idea!

[@BigBud2000]

Hi Dave, very good understandable video as always. I try to follow your guidance since I'm in touch with sql server version 2008 R2. Currently I'm trying to use polybase on a SQL Server 2019 installation for remote quering sql server databases and I wonder if you have any recommendations abount polybase performance tuning. Maybe this would be something for a new video?

[@PinalDaveSQLAuthority]

Good idea for the future videos.

[@pavanmadineni902]

Hi Pinal,
Could you please show some light on inner hash join/ left hash join hints usage.

[@PinalDaveSQLAuthority]

Sure. Good idea

[@abhay6276]

Hello pinal sir, on which column the primary key or the Cluster index is there? Because key look up only be there in the execution plan when there is Cluster index on a particular column...and if it is Cluster index then it must be Cluster index seek instead of non Cluster index seek as far as query concerned.please remove my confusion sir 😊🙏

[@PinalDaveSQLAuthority]

You can check the sample database AdventureWorks and Orders table directly and it will provide you all the necessary data.

[@tractor1969]

Pinal, have you seen cases where adding the include causes any issues? Logically I would not expect an unnecessary include to cause issues, unless the index were quite heavy. But as we often see, the engine can defy logic at times.
For example, in this case, you are selecting SalesPersonPersonId in the query and have added the include to satisfy this particular query. However, let's say you have another existing query that does not need that column. Maybe a query that joins on CustomerID and does not pull back SalesPersonPersonId. Have you seen issues where having the included column affects performance significantly enough that you kept both the non-include and include indexes to satisfy both queries?

[@PinalDaveSQLAuthority]

Very rarely. Not usual

[@kotekr4383]

wonderful sir.........

[@PinalDaveSQLAuthority]

So nice of you

[@akshatapatil9732]

Hi sir I have question can we use SQL server migration assistance for AWS redshift to azure SQL server database migration

[@PinalDaveSQLAuthority]

I have very little experience

[@Anti4pok]

Easy to understand, thank you! Wants more videos

[@PinalDaveSQLAuthority]

👍