SQL Server Internals Party: Storage, Memory and the Query Life-cycle

Come meet the Internals of SQL Server at this special get-together! In this presentation we will cover the basics of data storage and querying with SQL Server. We will cover how data is stored in pages and extents and how that translates to data reads/writes with the storage system. Additionally, we will explore how different queries are processed by SQL Server and how the query life cycle works in general. Finally we will cover disk storage and memory and tie it all together. This session is intended to be broad and to give a general overview of how a query is processed in SQL Server and how storage and memory play a part in that. Everyone is invited to this introductory level presentation and should be appealing to DBAs, DB & BI Developers and System Administrators. Party hats not included, rated G for Geeks.
Hosted by Steve Cantrell of DBAFundamentals
The basics for a rock solid foundation!
Full event description fundamentals.sqlpass.org/Meeti...

[@umermustafa2560]

This is an awesome video... I felt I was in need of this video it filled lot of knowledge gaps I had.

[@keithwiggans6898]

Thanks so much for the presentation. Great for people without a CS background.

[@rajendrasinghbisht6165]

Great presentation and wealth of information !

[@dragostolomei]

Very nice presentation, thanks !

[@user-dd5fs8uz5k]

very very good presentation thank you for uploading

[@channdeep]

Awesome. Must watch.

[@zaim4444]

great presentation

[@sudharshanreddy1472]

Can u pls explain Bufferpool extension option will improve the sql query performance

[@infotechadventure]

8 KB = 8000 Bytes
8.192 KB = 8192 Bytes

[@ConvoWithDragons]

You appear to be confusing the way that hard drive manufacturers measure with the way the binary system actually works.

[@infotechadventure]

Please enlightened me sir. Am I wrong with my conversion?

[@Finezzato]

He sounds a bit arrogant but very good presentation