Tuning SQL Server :-Why table Design matters
In this video we explain the impact bad table design has on performance. We explore the impact bad data types and lack of normalization can have. This is especially important for large tables where the minor changes have a cumulative effect on the ultimate performance. We explore how did you let the size of the table increases and results in parallelism as well as other significant IO characteristics that cause issues.
Need more information?
Visit https://www.enabledbusinesssolutions.com
To know more about Jayanth Kurup visit http://www.jayanthkurup.com
Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.
In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc
You can also reach Jayanth via his LinkedIn profile below
https://www.linkedin.com/in/jayanth-k...