Today I was diving into some extremely wide tables, I wanted to take a quick look at things like “How many unique values does this table have in every column?”. This can be super useful if you have a spreadsheet of results or a schema without effective normalization and you want to determine which rows […]
Update: T-SQL Notebooks in Azure Data Studio
It’s only been ten days since my first post about ADS Notebooks, and the team has already pushed out some super useful updates. Now launching an Azure Data Studio Notebook now is almost instantaneous. You are not prompted to install the other kernels unless you select them. When reopening a file, you no longer are […]
Removing non-numeric characters from a SQL Server field without UDFs or Regex
A great question came up in the SQL Community Slack today: I saw this as a great modification on my earlier post, and wanted to show another way to implement the same solution. Walking through the steps: First, use sys.objects as our example “target” and assume the string has less than 2024 characters (spt..numbers isnt […]