You have clearly explained the differance in very simple and understanable way! There may not be real performance diff under the hood but logically the differance in output resultset is big. Point to be noted!
Very well explained. I'm actually using operators instead of "between" in the search queries but to be frank i wasn't knowing about this. Thank you for the explanation.
All right, I'm finally following your instructions and liking/subscribing/commenting. :-) I really appreciate your short format videos and have been following them for awhile. I've made several changes to my SQL style based on your advice. Thank you and keep it coming!
@@PinalDaveSQLAuthority if datetime is stored as varchar (31/Dec/2021 02:56:34 AM) in the column, what will be best method performance wise to retrieve record of particular date.
Thanks for the sharing the info along with results. Actually i know about you from 2013 onwards. You are a genius in sql.
Wow, thanks
You have clearly explained the differance in very simple and understanable way! There may not be real performance diff under the hood but logically the differance in output resultset is big. Point to be noted!
Glad you liked this video.
Clear, succinct, and practical. Thank-you so much, Pinal!
My pleasure!
Very well explained. I'm actually using operators instead of "between" in the search queries but to be frank i wasn't knowing about this. Thank you for the explanation.
Glad to know that.
Dave Pinal, you are a professional & kind person. I really appreciate for sharing your knowledge & interesting issues with us. Thanks from New York
You are very welcome
All right, I'm finally following your instructions and liking/subscribing/commenting. :-) I really appreciate your short format videos and have been following them for awhile. I've made several changes to my SQL style based on your advice. Thank you and keep it coming!
So nice of you. Thank you
Well done video and the point about rounding in the milliseconds was a surprise. Thanks for pointing this out. Good job
Thank you.
Excellent example for a simple situation and very clear. Thanks pinal
Glad you liked it
I always use between, thanks for your video.
You are welcome!
Thank you sir for your explanation.
Welcome!
Thank you for the video
You are welcome
Perfectly explained
Thanka
Hi Pinal, I am waiting for video on resolving self blocking
Noted
Can you please make a Similar Performance video when DateTime is stored in a different format?
Would you please give me example please? I will do my best.
@@PinalDaveSQLAuthority if datetime is stored as varchar (31/Dec/2021 02:56:34 AM) in the column, what will be best method performance wise to retrieve record of particular date.
@@abhijeet834uthe column data type should be changed.
Hi can you please make an video to recover deleted records with out db backup
It is not possible.
Oh ok thanks for update
Lovely. No difference. I would like to see how we create table partitioning
Partition has no impact on performance
Sure! I am aware. Just wana see the implementation. Have you talked about it in any of your video?