How to Think Like the Engine Part 1
Вставка
- Опубліковано 19 лип 2024
- You've never had a formal class on Microsoft SQL Server before, and you want to learn how it works. I'll teach you using the Stack Overflow database printed out on a series of pages. Print the PDF to follow along: BrentOzar.com/go/engine
- Наука та технологія
Brent is a great instruction. I landed my first job as a database developer mostly thanks to his training.
Woohoo! That's great to hear!
This is still the best video I've ever seen as an introduction to what's going on under the hood. The analogies to a human physically retrieving data are super helpful and intuitive.
Wow, thank you!
Been following the content for 3 or 4 years now and it just keeps getting better and more clear. Thanks for all this amazing and free content.
Wow, thank you!
Just discovered your series. Recommended by my DBA. Good level of intensity and information density. Thanks
Thank you so much for providing this information to us for free!
Glad it was helpful!
This is a great video with an engaging presenter. I did pause at about 10min to go read docs on Pages and Extents Architecture.
Thanks, glad you liked it!
Awesome explanation and very easy to follow.
Glad it was helpful!
i'm tasked to improve some slow db queries... have done a first run through bunch of online resources but looks like I need to really understand whats going on. your course seems really great. thanks so much :)
awesome work.
Love the content Brent. IMHO all the transition sounds, all the sound board sounds, are a bit too loud. Maybe reduce it by 20%. The sounds are louder than your voice.
I know I don't have any mercy. You are so funny . Thanks for free class man.
Hahaha, thanks!
I love your reference to running SQL Server on a raspberry pie, so true. IKR, why am i having problems?
Heh heh heh!
When is good time to buy your course with offer. After listening 1st topic think like sql engine
During our annual Black Friday classes in November.
19:38 why scan all pages complet? Scanning the column last access on all pages should be enouth right?
Because in a real data page, the columns aren't organized in some kind of vertical order. SQL Server crams the data in as tightly as it can - so to find each row's last access date, SQL Server has to open the row, find the position of LastAccessDate, and then read it.
I like the mistake of the upsidedown paper.. it makes you human. Though we all know you're an alien with your TSQL knowledge. LOL
So this can't really convert to knowledge with mysql? I was trying to find some mysql info to start learning but would you recommend just working with MS SQL instead?
No, this is strictly about Microsoft SQL Server.
21:00 why is the where query reading more pages than select all query?
select all queries all possible pages where users data lies in right
Keep watching another 15 seconds and the answer's written on the screen. ;-)
Would this help me in case of MySql?
No
If I have a table with 100 columns and 1000 rows, how many pages do I have?
It would depend on the columns' datatypes and how full they are. Long names take more space than short names, for example.
But wait, why doesn't MSSQL just grab the ID and access date, sort by that, then go back to the clustered index and fetch rows by ID in the appropriate order?
Because you'd have to lock all those rows the whole time you were working. You ain't the only person tryin' to run a query around here, you know? ;-)
@@BrentOzarUnlimited what if you use row-versioning isolation?
@@MattiasFlodin That's a great question, and we explore that in our Mastering classes - but it's not the default for SQL Server.
I should curse Brent as after you have completed Brent's training other training courses seem very dull and boring...
I don't think Brent should be shot but it does remind me of the scene in The Adventures of Baron Munchausen:
Horatio Jackson: Ah, the officer who risked his life by singlehandedly destroying...
Functionary: [whispering in his ear] Six.
Horatio Jackson: *Six* enemy cannon and rescuing...
Functionary: Ten.
Horatio Jackson: Ten of our men held captive by The Turk.
Heroic Officer: Yes, sir.
Horatio Jackson: The officer about whom we've heard so much.
Heroic Officer: I suppose so, sir.
Horatio Jackson: Always taking risks far beyond the call of duty.
Heroic Officer: I only did my best, sir.
Horatio Jackson: Have him executed at once.
Soldier: Yes, sir. Come along.
Horatio Jackson: This sort of behavior is demoralizing for the ordinary soldiers and citizens who are trying to lead normal, simple, unexceptional lives. I think things are difficult enough as it is without these emotional people rocking the boat.
HA! Thanks, sir.
hahah Oracle is way better Larry Elson has an hawaiin island, msoft doesn't have a sail boat racing team, lmfao!😅, - oracle has many cool features like result set caching.
50% of the time... "Thou Speaks of Nothing"...