Create top N plus others summaries with deterministic category ranking, one remainder total, stable labels, and explicit display ordering.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Infinite Loop – SQL in Sixty Seconds #144
Lots of people wrote feedback about it and wanted me to explain in this video so I have built this new Video where I discuss Infinite Loop.
SQL SERVER – Change Database and Table Collation
To Change Database collation, I separate its default from existing character-column settings. The customer moved from case-insensitive to case-sensitive behavior.
WHILE 1 = 1 Loop in T-SQL: Run Forever, Stop Safely
A WHILE 1 = 1 loop never ends on its own, so every one needs a planned exit. This post builds a once-a-second sampler with three ways out, a stop flag, a round limit and a time limit, then shows how to stop a loop from a second window and what the recursion limit does.
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
Default Query Shortcuts in SSMS: Alt+F1, Ctrl+1 and Ctrl+2
The default query shortcuts in SSMS are Alt+F1, Ctrl+1 and Ctrl+2, and each runs a system procedure on the text you select. This post shows what sp_help, sp_who and sp_lock return, why sp_lock has a better replacement, and which keys you can change.
JOIN Elimination in SQL Server: When a Table Drops Out
JOIN elimination removes a joined table from the plan when the query does not need it. This post proves it with STATISTICS IO, then tests nine variations to show when it applies and when it does not, including a foreign key that has lost its trust.
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.