SQL Server JSON: Performance Cookbook

Sergii Syrovatchenko

Rate me:

5.00/5 (7 votes)

25 Jul 2021CPOL12 min read

24.8K

Here's everything you need to know about high-performance JSON parsing for SQL Server

In SQL Server 2017/2019, Microsoft significantly improved the performance of the already fast JSON parser. We will learn more about it in this article.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Sergii Syrovatchenko

Database Administrator DraftKings Inc.

Ukraine

SQL Server DBA/DB Developer with 10+ years of experience in SQL Server 2005-2019, Azure/GCP. Worked on high-load OLTP/DW projects and develops system tools for SQL Server. In depth understanding of SQL Server Engine and experience in working with big databases. Domain knowledge of ERP/CRM, crawlers, gambling and retail sales. Blogger, mentor and speaker at local SQL Server events.

SQL Server JSON: Performance Cookbook

Views

License

Comments and Discussions