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.
Holiday Change Freeze Checklist for SQL Server: What to Verify First
Use a change freeze checklist for SQL Server to verify backups, integrity checks, disk headroom, Agent jobs, and serious errors.
Apache Spark and Airflow in Action : My Experience
Recently, I’ve been working with a large client where we’re diving deep into Apache Spark and Apache Airflow. Let us learn!
SQL Server Performance Tuning in the Age of AI: An Expert’s Tale
My job? To figure out what went wrong and fix it. Let us talk about SQL Server Performance Tuning in the Age of AI.
SQL SERVER – Understanding WITH RECOMPILE in Stored Procedures
The culprit? Parameter sniffing. The solution? You guessed it: WITH RECOMPILE. Comprehensive Database Performance Health Check
SQL SERVER – Implementing Row-Level Security (RLS)
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.