Build an ordered clustered columnstore on SaleDate, compare segment ranges and skipped segments, and review how later loads affect order.
SQL SERVER – Query Store Feature for Secondary Replicas
SQL Server 2022 extends the Query Store feature for secondary replicas. Here is how to enable it and what to watch before using it.
Masking Functions in SQL Server: What Each One Shows
Dynamic data masking hides values at query time, and the masking functions decide what a reader still sees. This post tests default, email, partial, random and datetime on SQL Server 2025 and shows what each one returns. It also covers adding and dropping a mask on an existing column.
SQL SERVER 2022 – GENERATE_SERIES Function
Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.
SQL SERVER 2022 – Persistence and Percentile Memory Grant Feedback
We will particularly focus on Persistence and Percentile Memory Grant Feedback. Let us learn more about this feature of SQL Server 2022.
SQL Server 2022 – Cardinality Estimation (CE) Feedback for Performance
SQL Server 2022introduces an enhanced Cardinality Estimation (CE) feedback feature as part of the intelligent query processing family.
SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance
SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).