If you’ve spent any time wrangling data pipelines, you know that Apache Airflow is a staple in the orchestration world. Let us learn.
Automating SQL Server Deployments Across Multiple Databases Using Python
Let us learn about Automating SQL Server Deployments Across Multiple Databases Using Python. We have complete script in this blog.
SQL SERVER – Catching Non-SARGable Queries in Action
If you ever wondered why a query that looks harmless is performing poorly despite having indexes in place, the answer could non-SARGable queries.
SQL SERVER Performance Tuning: Catching Key Lookup in Action
In this blog post, we’ll explore what a Key Lookup is, how to spot it, and most importantly, how to eliminate it using a covering index.
ANSI PADDING and Storage – SQL in Sixty Seconds 210
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.
SSMS and Execution Timeout – SQL in Sixty Seconds 209
Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.
Performance and TempDB Spills – SQL in Sixty Seconds 208
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.
Deadlock and Profiler – SQL in Sixty Seconds 207
In today’s episode, we’ll explore how to simulate and capture deadlocks in SQL Server using the powerful SQL Server Profiler.
TOP vs. TOP PERCENT: Hidden Costs – SQL in Sixty Seconds 206
The hidden costs of using TOP versus TOP PERCENT clauses. Even if the results appear the same, the underlying performance can vary.
SQL in Sixty Seconds – CPU Threads and Uneven Workload
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.