Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,511 reads
Blog Posts
Selecting Speakers for the Summit
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-23
491 reads
Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
532 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
1,071 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
534 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
7 reads
Database snapshots
This feature is Enterprise only which can limit who it is useful to, but I find the whole concept fascinating....
2016-06-22
502 reads
I am speaking at SQL Saturday Indy 2016!
That’s right, back-to-back roll. I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud...
2016-06-22
6 reads
I am speaking at SQL Saturday Indy 2016!
That’s right, back-to-back roll. I will be presenting my second SQLSaturday session at the upcoming Indianapolis #530, Saturday, Aug. 13th,...
2016-06-22
135 reads
Join Me at PASS Summit 2016
It seems like it was just yesterday that we all said goodbye in Seattle at last year’s PASS Summit, but...
2016-06-22
349 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers