What is Index Scan ,Index Seek and Table Scan?||SQLSERVER  

Its true!

Yes.

This is basically you are talking about scan operation on covering index i.e non clustered index .I have video on that .please check it out. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yefP63XqlpY.html

Is it helpful Janhavi!

Ty

@@sqliseasy what is the better way to check, whether the table or sp's are indexed or not?

Highlight table name or select .then press Alt + F1

Thank you Melvis.

Thanks and welcome

thank you.

Thank you for your valuable feedback.

You are welcome!

Glad it was helpful!

Time taken to complete operator execution.

Time taken to complete operator execution. If you are running query "select * from tablename" and if see execution plan for it. You will see different boxes. These boxes are called as operator and if you hover every operator you will see different matrices such as estimated cost , actual cost and many more.

Thanks Anil.

Thank you.

Thanks Abhishek.

Glad you liked it

please create one video of one to one pivot and many to one pivot

Video is live.please check out

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qaLU7YH39kE.html

Thanks Sriram.

Thanks a lot Ashish .Please let me know if you want to create videos for you!!!

yes shri... can you give my your contact no

Thanks a lot +Pani for your feedback

+Apan Aggarwal Thanks

Thanks Saul.