SQL Internals - Physical Table Structure, and Implementation On Real Case Scenarios By Ronen Ariely

SQL Internals – Physical Table Structure, and Implementation On Real Case Scenarios By Ronen Ariely

Session Title: SQL Internals – Physical Table Structure, and Implementation On Real Case Scenarios
Speaker: Ronen Ariely

Abstract: Understanding what we have under the hood is not only done for the sake of learning 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 the tables behind the scenes. I will show the changes in the table structure behind the scenes, related to actions which we execute on the table. Using this information, I will demonstrate several real case scenarios and the dramatic impact of understanding the internals in choosing our solution.

Is the order of the columns in the Create Table statement important? Can a specific order of columns affect performance or lead to an error in the future use of the table? Is dropping a column that is no longer needed is the right solution? Questions like these are very common in forums, but usually do not get the right answers even from experts.