SQL Server 2019 Intelligent Query Processing by Dean Savović || SQL Server Virtual Conference

Dean Savović talks about new intelligent query processing features in SQL Server 2019. The features that will be described are adaptive joins, interleaved execution, memory grant feedback, table variable deferred execution, batch mode on rowstore, T-SQL scalar UDF inlining, and approximate count distinct.

About Speaker:
Dean is a Senior DBA practicing SQL Server since version 7.0 and the main areas of interest are performance tuning and troubleshooting SQL Server database. The primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished the Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that helps us in our everyday work. He works in SPAN which is specialized in the data management field on Microsoft SQL Server.

C# Corner - Community of Software and Data Developers

#SQL #Bigdata #conference #sqlserver #t-sql #BI #IQP #query