I can Remove Duplicate characters while preserving their first-occurrence order. This second method uses explicit positions and ordered aggregation.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
How to Insert Line Break in SQL Server String? – Interview Question of the Week #139
How do you insert a Line Break in a SQL Server string? Just press Enter inside the string, and switch SSMS results to text to see it. Here is how it works.
SQL SERVER – Unable to Get Listener Properties Using PowerShell – An Error Occurred Opening Resource
A client could not change listener properties with PowerShell and got “An error occurred opening resource”. Here is the T-SQL query I shared and what fixed it.
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Want to know which columns uniquely identify a row in a table? The system stored procedure sp_special_columns tells you. Here is a quick demo.
SQL SERVER – System Procedure to List Out Table From Linked Server
The System Procedure sp_tables_ex lists table metadata from an existing linked server. I check its provider and login mapping separately.
ROWCOUNT and PAGECOUNT: Faking a Big Table to Test Plans
You can tell the optimizer a three-row table has 10 million rows and watch the plan change. Here is how, and how to undo it.
SQL SERVER – Different Methods to Know COMPATIBILITY LEVEL of a Database
Different methods to find the compatibility level of a database, from sp_helpdb to sp_dbcmptlevel, with a quick note on what the setting means.
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.