T-SQL - Is Saving Space Worth It?
I ran across this blog post on Joe Celko’s Restaurant Seat Assignment Problem that found a way to implement the...
2010-09-09
302 reads
Blog Posts
Voting Theory
I was enjoyed the Sunday newspaper (on Sunday!) and ran across this column about various voting systems and that made...
2010-09-09
427 reads
A week far away...24 HOP!
I just have an email with notice that 24 Hours Of PASS, is a week far away! Once again great...
2010-09-08
639 reads
Common SQL Server Mistakes – GUID as a Clustered PK
I haven’t been thrilled with GUIDs as primary keys, mainly because I think that it’s hard for humans to work...
2010-09-08
1,472 reads
Interview with SQL Server MVP Allen White
This is the third and last in a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL...
2010-09-08
796 reads
MDX - Calculating the Percent of a Named Set
Getting the percent of something in MDX seems like a pretty easy task but can be complicated when extra logic...
2010-09-08
1,131 reads
New Ideas for SQLSaturday
Jack Corbett and I are trying a few new things at SQLSaturday #49 in Orlando this year (Oct 16, 2010)...
2010-09-08
262 reads
Schedule the backup job in Express Edition
Schedule the backup job in Express Edition: Everyone knows that, you cannot schedule a job in Express edition, as Express...
2010-09-08
463 reads
September S3OLV
Here is another short reminder about this months UG meeting in Las Vegas.
We will be meeting Thursday at the same...
2010-09-08
496 reads
September TSQL Tuesday
It is hard to believe that time is flying like it is. Already it has been a month since I...
2010-09-08
522 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
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
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