To list all jobs with owners, read the job table in msdb and resolve each owner with a join that keeps jobs without a login. This post builds four demo jobs, shows how a common query hides one of them, and reassigns jobs safely. It ends with a cleanup script.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
TempDB Metadata Tables: Check, Enable and Count Them
The tempdb metadata tables can live in memory, and four short steps tell you whether yours do. This post checks the setting, shows how to turn it on and off, and counts the tables SQL Server moves. It also says when the feature is worth a restart.
Additional Logging for SQL Server Agent: Three Methods
Additional logging for SQL Server Agent means raising the Agent error log level, so the Agent writes more lines about its own work. This post reads the current level, changes it with T-SQL and restores it in the same script, and shows the Management Studio and registry routes.
Display Rupee Symbol in SSMS and T-SQL With FORMAT
To display rupee symbol and Indian digit grouping in SSMS, format the number with an Indian culture, or use the Unicode character 8377. This post compares en-IN, hi-IN, gu-IN and kn-IN, shows the nvarchar rule that keeps the symbol from turning into a question mark, and formats dates for the same cultures.
What are Different Methods to Know the Row Count of Table? – Interview Question of the Week #261
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
SQL SERVER – Heaps, Scans and RID Lookup
The question was do heaps are very bad and always force a table scan? Let us learn about RID Lookup, Heaps and table scan.
Capturing sp_WhoIsActive Snapshots to a Table Every Minute
Capture sp_WhoIsActive snapshots every minute, keep seven days, and query past blockers and long requests from a logging table.
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.