T-SQL Tuesday #80 – SQL Birthday Present
It’s time for another round of the global blog party we call T-SQL Tuesday. This is T-SQL Tuesday #80 and...
2016-07-12
765 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Possible Infinite Recompile Was Detected for SQLHANDLE
On one of my SQL Server instances, I see a lot of these infinite recompile messages in the SQL log....
2016-07-01
2,242 reads
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
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-17
781 reads
AG Worker Thread Blocked by Log Backup
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...
2016-06-15 (first published: 2016-06-06)
2,118 reads
What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...
2016-06-08 (first published: 2016-06-01)
2,684 reads
Attendee Questions from My #24HoP Presentation
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
789 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,176 reads
My 24 Hours of PASS Session Files
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
985 reads
Why I'm not attending PASS Summit 2016
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,098 reads
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers