Are these pages the reason why when I view the properties of a file in windows explorer there are two displays? One says "file size" and the other says "size on disk" (I don't remember exactly what they're called)
Kind of but not entirely. Files can be attached to other files in hidden partitions. The size on disk can sometimes be bigger than its size when there is another file that's attached, sometimes viruses use this to hide programming and/or even file backups like photos or videos the spyware is tracking incase you ever delete them
Why do you give examples with inserting rowid(5), then rowid(3), then rowid(10), for example. I usually assume that rows ids are actually inserted chronologically ordered i.e rowid(1), rowid(2), so forth, assuming ids are sequentially incremented. I that this has to be set while you creating the primary key of the table, but anyway it should exist, no? If not, is it realistic that row ids are created in a random manner like the examples you made, or is it just for illustration? I hope I am not totally understanding your talk the other way around 😄
kindly add a few pictures and diagram so it will be easy to understand the concept well instaed of showing off urself.. this is technical videos and not some chitchat... stop behaving like hollywood star.
I love this channel, These types of videos remind of some of the most engage lectures I've had back in college
Videos are always great. Thank you!
Interesting topic, best regards Hussein.
Hussein, you are the best!
Thanks for making this video. Very informative.
Are these pages the reason why when I view the properties of a file in windows explorer there are two displays? One says "file size" and the other says "size on disk" (I don't remember exactly what they're called)
Yes
Kind of but not entirely. Files can be attached to other files in hidden partitions. The size on disk can sometimes be bigger than its size when there is another file that's attached, sometimes viruses use this to hide programming and/or even file backups like photos or videos the spyware is tracking incase you ever delete them
I wonder what the difference is between calm and relaxed Hussein (in this video), and excitable Hussein (in some other videos).
Hussein there is no link in 12:44
My man is a Batman fan. He has a batarang on his lips.
jk
excellent video.
Why do you give examples with inserting rowid(5), then rowid(3), then rowid(10), for example. I usually assume that rows ids are actually inserted chronologically ordered i.e rowid(1), rowid(2), so forth, assuming ids are sequentially incremented. I that this has to be set while you creating the primary key of the table, but anyway it should exist, no?
If not, is it realistic that row ids are created in a random manner like the examples you made, or is it just for illustration? I hope I am not totally understanding your talk the other way around 😄
kindly add a few pictures and diagram so it will be easy to understand the concept well instaed of showing off urself.. this is technical videos and not some chitchat... stop behaving like hollywood star.