May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Query Store Feature for Secondary Replicas

September 14, 2023
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Query Store, SQL Server 2022

the Query Store for secondary replicas. This feature extends the Query Store functionality from primary replicas to secondary replica workloads.

Read More
generate series

SQL SERVER 2022 – GENERATE_SERIES Function

July 20, 2023
Pinal Dave
SQL Tips and Tricks
GENERATE_SERIES, SQL Function, SQL Server 2022

Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.

Read More
Persistence and Percentile

SQL SERVER 2022 – Persistence and Percentile Memory Grant Feedback

June 28, 2023
Pinal Dave
SQL Performance
Memory Grant, SQL Memory, SQL Server 2022

We will particularly focus on Persistence and Percentile Memory Grant Feedback. Let us learn more about this feature of SQL Server 2022.

Read More
Cardinality Estimation

SQL Server 2022 – Cardinality Estimation (CE) Feedback for Performance

June 27, 2023
Pinal Dave
SQL Performance
Cardinality, Compatibility Level, Query Store, SQL Server 2022

SQL Server 2022introduces an enhanced Cardinality Estimation (CE) feedback feature as part of the intelligent query processing family.

Read More

SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance

June 26, 2023
Pinal Dave
SQL Performance
Compatibility Level, Database Scoped Configurations, MAXDOP, Parallel, Query Store, SQL CPU, SQL DMV, SQL Server 2022, SQL Server Configuration

SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).

Read More
last-valid-restore-time

SQL SERVER 2022 – Last Valid Restore Time – Improved Backup Metadata

June 2, 2023
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server 2022

One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.

Read More
Buffer Pool Scan

SQL Server 2022 Performance – Buffer Pool Scan

May 24, 2023
Pinal Dave
SQL Performance
Buffer Pool, SQL Memory, SQL Server 2022

One aspect that can significantly impact performance is scanning the buffer pool in Microsoft SQL Server. This blog explores buffer pool scan.

Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version