Boost SQL Server Priority appeared in the historical SSMS 18.5.1 interface. I showed where to inspect that engine setting.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Identify Index Used for Query – SQL in Sixty Seconds #088
How do you identify index used for query? It is a popular question in my health checks, and this SQL in Sixty Seconds video shows the easy way.
Count TempDB Data Files: Five Ways to Check in SQL Server
You can count tempdb data files with the Properties window, three queries or the error log. This post shows all five checks with their results, explains what each one reads, and compares the count with the number of CPUs. It also covers the case where the Properties window won’t open.
Background Job Queue: List Active Jobs and Kill a Stats Job
The background job queue holds work that SQL Server runs outside your queries, such as asynchronous statistics updates. This post lists the active jobs, reads the queue counters, catches a real statistics job in a demo and kills it with KILL STATS JOB. It also corrects a common mix-up: the command takes the job ID, not the session ID.
Finding Queries the Application Cancelled With Attention Events
Capture attention events for canceled requests, read event-file XML, compare Query Store aborts, and inspect transaction cleanup.
Query Percentage Complete: Watch a Long Query Finish
Query percentage complete is not a column in any view, but sys.dm_exec_query_profiles reports how many rows each operator has produced against the plan’s estimate. This post builds a monitor query for a running statement, explains why a percentage can pass 100 or even run into the thousands, and shows which operators to trust.
How to Combine Time and Date in SQL SERVER? – Interview Question of the Week #285
Question: How to Combine Time and Date in SQL SERVER?
Answer: A very simple and popular question. Let us learn together.
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.