To keep only digits in a column, a CHECK constraint with NOT LIKE and a character range works, but it has two holes. It accepts an empty string and digits from other scripts. A demo closes both and shows NULL, trust and fixed length codes.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Zoom in SSMS – SQL in Sixty Seconds #153
It is possible to zoom in SSMS (SQL Server Management Studio). A client asked me during a Health Check, so here is how to do it.
ALTER SCHEMA TRANSFER: Move a Table to Another Schema
ALTER SCHEMA TRANSFER moves a table to another schema and leaves repairs behind. A demo shows that permissions disappear and views break while the data stays. It also shows a synonym that keeps old queries working.
Find a Table in Execution Plan – SQL in Sixty Seconds #151
Finding a table in a huge execution plan is a nightmare. In this SQL in Sixty Seconds video, I show how to find any table in execution plan with SSMS.
LTRIM and RTRIM With Custom Characters in SQL Server 2022
Use LTRIM and RTRIM with custom characters in SQL Server 2022, understand character sets, test TRIM directions, and preserve valid text.
Search a Query Plan for a Table: Find Node and XQuery
Search a query plan for a table with the Find Node feature in SSMS, or with XQuery over the plan XML. A demo query reads one table twice, and both methods find both visits. The post also shows how to save a plan file for later.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
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.