Question: How to Download the Latest SQL Server Docker Image? Answer: The command to download the latest SQL Server Docker Image is here:
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Idle CPU Condition in SQL Server Agent: How It Works
The idle CPU condition tells SQL Server Agent when the CPUs are quiet enough to start a job. This post shows where to set it, how the two numbers work and how to create the schedule. It also reads the CPU history of your server in T-SQL, so you can choose values that the server can actually meet.
SQL SERVER – Strange Error Related to Alias
They immediately paid for Comprehensive Database Performance Health Check and we got online to look at their strange error related to alias.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.
ROWCOUNT_BIG and @@ROWCOUNT: Checking What a Statement Changed
Capture ROWCOUNT_BIG immediately after a change, validate expected counts, and handle NOCOUNT, triggers, and MERGE without stale values.
Get Partition Info in SQL Server: Rows and Boundaries
To get partition info in SQL Server, join sys.partitions to the partition scheme, function and filegroup views. This post builds a small partitioned table, lists every partition with its boundaries, row count and filegroup, and shows how to find the partition for a value. It also lists the tables that have more than one partition.
SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT
Today we are going to discuss the performance comparison of table variables and temp tables when we are running SELECT queries.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.
Who We Are
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.
Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.
Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).
Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.
Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

