Database Animations: How SQL Server’s JSON Indexes Work

Performance Tuning Database Animations: How SQL Server’s JSON Indexes Work By Brent Ozar · September 9, 2026 · no comments By popular demand, SQL Server 2025 added JSON indexes. You can eat the cake of being able to store practically schema-less JSON blobs as part of each row, and have it too by querying specific values quickly. (The common phrase is to “have your cake and eat it too”, but did you