A document search on a billion row "EAV" table is predicted to take 134 days. With a few design tweaks and an efficient relational division algorithm, Peter Larsson got it down to milliseconds.
2024-08-07 (first published: 2013-12-09)
3,460 reads
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
2024-08-05 (first published: 2019-09-11)
384 reads
We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]
2024-08-04 (first published: 2024-08-03)
105 reads
A few recent disasters inspire Steve to remind you to prepare now, before a disaster occurs.
2024-08-02
139 reads
2024-07-31 (first published: 2019-09-20)
682 reads
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
2024-07-29
171 reads
You know I have to say something about Crowdstrike. How could I not? Recovery for most people seems to be well in hand, but there are still places dealing with it. I was personally impacted because I was trying to fly home last Friday. While my airline and the airports I was flying through were […]
2024-07-27
159 reads
Table variables have been fixed in SQL 2019, so now I have to decide if I will use them again.
2024-07-26 (first published: 2018-12-11)
392 reads
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
2024-07-24
170 reads
What are the biggest challenges you face today? Steve asks the question and is hoping for a few answers from you.
2024-07-22
209 reads
By James Serra
If you are migrating a data warehouse, there is a question worth asking before...
By Steve Jones
I’m back from a great vacation. I had the chance to visit two new...
Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...
Comments posted to this topic are about the item DML Trigger Types
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Comments posted to this topic are about the item Choose the Second One
How many types of DML triggers are there?
See possible answers