Alex Grinberg

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”.

In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few.

In the last releases, SQL Server development was enriched with new T-SQL features, such as CTE (common table extension), array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few.

This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration.

In the last releases, SQL Server development was enriched with new T-SQL features, such as STRING_AGG, STRING_SPLIT, TRANSLATE array of Ranking and Windowing functions (ROW_NUMBER, RANK, DENSE_RANK, TILE), MERGE statement, OUTPUT clause, EXCEPT and INTERSECT just to name a few.

In the modern world of information technology, SQL Server DBA tasks exceed typical Administration and T-SQL development. Each new SQL Server version brings additional technologies that help streamline and improve its functionalities.