The goal of the DBA Virtual Group is to provide a PASS community for the DBA. It provides a forum for open discussion and education on issues that face SQL Server database administrators.

Sign in to Subscribe

SQL Internals - Physical Table Structure under the hood, and implementation on real case scenarios

Wed, Mar 13 2019 18:00 UTC

SQL Internals - Physical Table Structure under the hood, and implementation on real case scenarios

Understanding what we have under the hood is not only done for the sake of learning a theory, but it directly impacts your daily work, and it can help us to improve performance and reduce resources dramatically. During this session we will go over the structure of tables behind the scenes. We will see the changes behind the scenes related to DDL actions which we execute on tables. Using this information, I will demonstrate several real case scenarios, and the dramatic impact of understanding the internals on choosing our solution Is the order of columns important? Is dropping a column the right solution? Questions like those are very common in the forums and usually does not get the right answers. The answers might be a game changer in production environment This session is a live demo! You can find this demo here: http://ariely.info/Blog/tabid/83/EntryId/226/SQL-Internals-Physical-Table-Structure-under-the-hood-and-implementation-on-real-case-scenarios.aspx


Ronen Ariely

Ronen Ariely is a senior consultant, an applications & data architect. He has more than 15 years' experience in variety programming languages and technologies, leading development teams and software companies in enterprise level solutions in the fields of Data Platforms, BI, and developing. Ronen is active in communities (aka pituach) in the fields of Microsoft Azure, SQL Server, T-SQL, and Dot.Net programming. He serves as Moderator at MSDN and as one of the Microsoft TechNet WIKI communities' leaders. Ronen writes technical blogs, TechNet articles and blogs, he is co-admin of Microsoft's blogs "TechNet WIki" and "MSDN Forum", and has been awarded as Microsoft Most Valuable Professional.

Interested in Presenting at the DBA VG?

We can always use people to give a talk at one of our bi-monthly events. If you are interested in giving a presentation, please send your title, a brief abstract and a brief bio to DBA VG Leadership Team.

Want to become a member of the DBA VG Leadership team?

Members of this team moderate meetings and interact with the speakers during the Q&A sessions. Contact DBA VG Leadership Team, if you'd like to become part of the team.

Have a speaker to recommend?

Send the email address of the proposed speaker together with any relevant information about the speaker to DBA VG Leadership Team.

 

Meeting Recordings

The DBA Virtual Group presentations are recorded. On the Meeting Archive page, you will find  .WMV files that can be viewed on-line. Select the event you are interested in, click the Show More button if it is visible, and the recording and any associated files will be visible.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids