Previous Article Next Article SQL Server Internals Party: Storage, Memory and the Query Life-cycle
Posted in Sql

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

SQL Server Internals Party: Storage, Memory and the Query Life-cycle Posted on May 17, 201811 Comments



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 http://fundamentals.sqlpass.org/MeetingDetails.aspx?EventID=1191

11 comments

Leave a Reply

Your email address will not be published. Required fields are marked *