July 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 – Replacing a Cursor with a Common Table Expression

July 3, 2023
Pinal Dave
SQL Performance
CTE, SQL Cursor, SQL String

Let us learn today – How I was able to improve the query performance by replacing the cursor with a common table expression (CTE).

Read More
thread pool

SQL SERVER – Thread Pool Waits: Monitoring and Optimization

June 30, 2023
Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL Wait Stats, Threadpool

Thread pool waits management plays a vital role in maximizing the utilization of threads and ensuring the smooth execution of tasks.

Read More
deadlock priority

SQL SERVER – Setting Deadlock Priority to Control the Transaction that is Rolled Back

June 29, 2023
Pinal Dave
SQL Performance
Deadlock, SQL Transactions

In this article, we will explore Setting Deadlock Priority to Control the Rolled Back Transaction. Let us explore more in this blog post.

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
SQL Server Deadlocks

SQL Server Deadlocks – Interview Q and A

June 23, 2023
Pinal Dave
SQL Interview Questions and Answers
Deadlock, SQL Performance

Earlier this week, I wrote a few blog posts on SQL Server Deadlocks. Lots of people asked me if I could convert them into Interview Questions and Answers

Read More
Previous 1 … 19 20 21 22 23 24 25 … 828 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version