SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
LEFT JOIN ON Clause: Conditions Decide Matches, Not Rows
Why a condition in ON keeps every customer, why a left-side condition removes nobody, and how one WHERE quietly undoes two LEFT JOINs.
Trace Flags Worth Knowing About
Review trace flags worth knowing about in current SQL Server, distinguish session, global, and startup scope, and verify each flag’s support.
SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
I thought adding a column filter in SQL Server Profiler would lower CPU load. My test with large sample data showed the opposite: the filter raised CPU usage.
NULLIF Text: Collation Decides Whether Values Match
NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.
End-of-Day Balances From a Transaction Table
A transaction table stores movements, not balances. Collapse each day, run a total, fill the quiet days and dodge the midnight trap.
SQL SERVER – Pad Right Side of Number with 0 – Fixed Width Number Display
A reader needed a fixed width number display, like 1 shown as 0000001. SQL Server has no ready-made function, but a simple string trick does it.
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.