SQL Server Query Optimization Webcast, San Diego SQL Server Group
HTML-код
- Опубликовано: 7 сен 2024
- This is my first international speech at SQL Saturday San Diego's event.
It was at 18.07.20024, 18:30 PM USA time
and 19.07.20024, 04:30 AM TR Time.
I talked about SQL Server performance and query optimization techniques.
I have big datasets and live demos.
My presentation title is "Performance tip to rocket your queries"
I talked about,
-What does performance mean in SQL Server?
-How can we determine the performance killer queries in SQL Server?
-Performance improvement techniques in SQL Server.
-Index management and how to create the right index (Composite index order, included column, primary key, columnstore index etc...)
-Query optimization techniques (union, temp table, table variable, text search, using function at where condition)
-Choosing the correct SQL Server object for the scenarios (function, procedure, view etc...)
-Linked server usage and tricks
-And off course AI. How to use AI in SQL Server Query Optimization.
I have lots of demos and scenarios.
Thank you for the excellent broadcast, it was really enjoyable.
Thanks for everything.
Thank you very much. 10 numbers