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,091 reads
All sorts of project and organizational analysis go into selecting the right database system for the requirements....or so you'd think.
2022-08-27
195 reads
The whole universe, the well-guarded people—may they all query databases together in a single language!
2022-08-13
229 reads
For many years now we always seem to have been on the verge of the revolution in object databases, without it ever quite transpiring. Why is this?
2017-02-21 (first published: 2009-06-17)
718 reads
Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.
2015-04-20
135 reads
The next time you are tempted to hammer a performance problem with hardware, why not instead invest that time in hammering and refining your SQL queries? There are rich rewards to be had.
2014-12-26 (first published: 2009-11-02)
534 reads
There is a paradox in the nature of the abstractions that many developers want when dealing with databases. They will strain at the gnat, but swallow a camel (Matthew 23:24). Whereas they will recoil with horror when a DBA suggests that an abstraction layer based on views, functions and procedures in a separate database schema […]
2014-09-15
178 reads
What often starts out as a simple, quick process, gradually expands over time, as developers use SQL Agent to schedule new data feeds, add more complex transformations...
2013-10-28
209 reads
We know a lot about how great exponents of the DBA profession work, but the role is changing rapidly. What makes a great Data Scientist? Or a great BI specialist?
2013-06-24
263 reads
While backup to the Cloud may be useful in terms of optimizing storage across the enterprise, for DBAs it remains essential that they retain fast, easy, access to the backup files. Azure Explorer is a free tool that might help.
2013-04-29
60 reads
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
In a containerized app, React and Chakra UI provide a robust and accessible user...
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
hi, I have a table called Rules Create table Rules ( Id int ,...
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Hi Team, I am planning to apply security updates for SQL Server 2016 on...
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers