Kevin Kline - SQL Server Internals and architecture

Hi Kevin.... I told my son I can make pal with you by database reply me

Thanks, Kevin, for taking the time to make it easy to digest.

Very goo content

I have covered one session abt ARCHITECTURE

Good one 👍

Hi Kevin, I wanted to know any co-relation between the removal of any plan from the plan cache and the corresponding data present in the buffer cache. While removing the plan from the plan cache by the lazy writer does it also perform any action to remove the corresponding data page from the buffer cache. What if happens if there is plan in the plan cache but not present in the buffer cache.

Awesome session...
What happens to the data in the transaction log and has not been written to the disk (mdf). if in that mean time the server crashes?

One of us is seriously confused about what Atomic and Consistent mean.  Atomic doesn't remotely mean that a transaction "doesn't do multiple things"; it means that the entire transaction goes as an indivisible unit--precisely so that, if you want to do more than one thing (debit one account and credit another), it either all happens or none of it does.  Consistent doesn't mean a transaction does the same thing every time you run it, but that the database transitions from one relationally-consistent state to another.  It has nothing to do with repeatability.  I'm hoping this gets a lot better, fast.  The first two substantive things he said about databases seem to be flat-out wrong.

Hi kevin
what is the actual job of query executor?

Did he say ACID?

Awesome!

Wow. I learned a lot

Thank you Kevin, this is very helpful.

Very interesting, i did not know about optimizer, funny thing

Why were databases created in the first place. To make money for companies. Never thought bout it that way before

Wow, that was very educational. KK is like the CK Louis of SQL teaching. Many thanks for the upload!

How & who does load the newly created Plan from Query Optimizer to Plan cache???

examples for consistant and isolated trasaction didnt make sense.. Wikipedia has good example to understand these concepts

Best Session!!

Hi Kevin does it use MRU(Most rectently used for frequently running plans),LRU will be in bottom of buffer cache?

Thanks for uploading this Kevin..

This is great, helps understand the internals nicely, thanks Kevin,

grt

super kevin, this video gives the 100% clarity about the internal architecture of sql.

Thanks A Lot Kevin..
One of the best explanation..

Thanks Kevin!!! You helped me learn the SQL architecture to an extent.

Thanks Kevin for this excellent presentation !!!

very informative video... thanks

Kevin Thanks a lot
what is difference between Best plan and optimal plan ---thanks 

from where can we get the slides 

Amazing, thanks for that.

Hi Kevin, In the video you said you gonna tell about trouble shooting of 30 MB execution plan. Do you have a blog or video about working on that issue?

Kevin 
it is great and you refreshed (F5) me on ACID
thank you