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,374 reads
Today we have a guest editorial from Jim Youmans that asks "what does it mean to be a DBA today?"
2013-12-06
406 reads
Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.
2016-12-22 (first published: 2013-12-05)
282 reads
Would you rather work with people, or compete with them? Steve Jones has comments on the Microsoft Stack Ranking system that seems to encourage the latter.
2013-12-04
161 reads
Today Steve Jones talks about the challenges of preserving data across long periods of time, decades perhaps.
2016-12-26 (first published: 2013-12-03)
141 reads
An RDBMS is a good fit for many database problems, perhaps as Steve Jones thinks, the best fit for most. However NoSQL systems have a place, we're just not sure where.
2013-12-02
232 reads
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
216 reads
2013-11-28
101 reads
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
177 reads
Steve Jones has some concerns over new options in SQL Server 2014 that might lead some customers to experiment in a way that causes them unexpected pain.
2013-11-25
79 reads
Next up in my series talking about The Burrito Bot is diving into the...
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers