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,391 reads
Achieving high availability is hard. Today Steve discusses the challenges of five nines of uptime.
2024-08-05 (first published: 2019-09-11)
361 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)
66 reads
A few recent disasters inspire Steve to remind you to prepare now, before a disaster occurs.
2024-08-02
116 reads
2024-07-31 (first published: 2019-09-20)
637 reads
Steve has a quick turnaround between trips that was a bit unexpected. Is there compensation for this?
2024-07-29
158 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
147 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)
342 reads
Steve is thinking about technology today, inspired by a developer/architect that asks some philosophical and moral questions of software.
2024-07-24
162 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
194 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
WA CS (08218154392) Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut, Jawa...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers