XVI VDPUG meeting (подія в архіві)

Speaker: Andriy Zrobok, Database Developer EPAM

Topic: MS SQL Server: Query processing — Advanced query processing — Intelligent query processing. The road length of 20 years.

● History overview: how it works since 1998, basic principles, best practices vs new features.

● Advanced query processing — significant changes in Column Store & Batch mode. Adaptive query processing addresses issues related to cardinality estimates in execution plans, leading to better memory allocation, join type selection, and row calculations for multi-statement table valued functions (MSTVFs).

● Intelligent query processing — modification of Row Store processing. The Intelligent query processing feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort. You can automatically benefit from this feature family by moving to the applicable database compatibility level.

About Andrii:

25+ years of experience in database development: development data-centric applications from scratch, support of legacy databases/applications, data migration tasks, performance tuning, consulting, database trainer.

I have experience with wide range of databases such as FoxPro for DOS (Fox Software), MS SQL Server (6.5 — 2017), Oracle, Sybase ASE, MySQL, PostgreSQL.

Co-Leader of PASS Local Chapter in Lviv.

Speaker at PASS SQLSaturday conferences (since 2013); PASS Lviv/Vinnytsia/Virtual SQL Server User Group, EPAM IT Week (2015-2017).

Facebook

Tickets