SQL Authority Blog
3,225 FOLLOWERS
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 20 years of hands-on experience. His Blog covers latest news, and information on SQL Server Performance Tuning Issues.
SQL Authority Blog
2M ago
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.
First appeared on ANSI PADDING and Storage – SQL in Sixty Seconds 210 ..read more
SQL Authority Blog
2M ago
Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.
First appeared on SSMS and Execution Timeout – SQL in Sixty Seconds 209 ..read more
SQL Authority Blog
2M ago
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.
First appeared on Performance and TempDB Spills – SQL in Sixty Seconds 208 ..read more
SQL Authority Blog
2M ago
In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.
First appeared on Deadlock and Profiler – SQL in Sixty Seconds 207 ..read more
SQL Authority Blog
2M ago
The hidden costs of using TOP versus TOP PERCENT clauses. Even if the results appear the same, the underlying performance can vary.
First appeared on TOP vs. TOP PERCENT: Hidden Costs – SQL in Sixty Seconds 206 ..read more
SQL Authority Blog
2M ago
When SQL Server executes a query in parallel, CPU threads often share the workload unevenly. Some handle a significant portion of the rows, while others manage much less.
First appeared on SQL in Sixty Seconds – CPU Threads and Uneven Workload ..read more
SQL Authority Blog
2M ago
I want to take a moment to extend my heartfelt wishes for a wonderful season and an even better year ahead. I have some learning opportunities for everyone in this blog post.
First appeared on Warm Holiday Wishes and Learning Opportunities ..read more
SQL Authority Blog
3M ago
Row-Level Security (RLS) in SQL Server enables fine-grained control over data access, ensuring users can only view or modify rows pertinent to their roles or responsibilities.
First appeared on SQL SERVER – Implementing Row-Level Security (RLS ..read more
SQL Authority Blog
3M ago
Recently, I’ve been working with a large client where we’re diving deep into Apache Spark and Apache Airflow. Let us learn!
First appeared on Apache Spark and Airflow in Action : My Experience ..read more
SQL Authority Blog
3M ago
My job? To figure out what went wrong and fix it. Let us talk about SQL Server Performance Tuning in the Age of AI.
First appeared on SQL Server Performance Tuning in the Age of AI: An Expert’s Tale ..read more