Conditional Aggregates
The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...
2014-02-11 (first published: 2014-02-04)
3,092 reads
Blog Posts
Correlation Does Not Imply Causation
One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...
2014-02-11
1,508 reads
DELETE operations on tables
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-11
902 reads
Enterprise-class real-time stream analytics for Big Data
Since the beginning of the information age, enterprises have relied on processing data to gain insights and make business decisions....
2014-02-11
1,306 reads
Four steps to identify and relocate an application portfolio to the cloud
Large enterprises looking for ways to modernize and migrate a portfolio of business applications to cloud will need to adopt...
2014-02-11
553 reads
HDFS Explorer – Manage HDFS Storage from Windows
f you’re planning to use HDFS Explorer with the Hortonworks Sandbox or Cloudera VM, you’ll need to define your Hadoop...
2014-02-11
1,505 reads
Impala Performance Update: Now Reaching DBMS-Class Speed #cloudera #bigdata
Since the initial beta release of Cloudera Impala more than one year ago (October 2012), we’ve been committed to regularly...
2014-02-11
489 reads
MapReduce On Hive Tables Using HCatalog
HCatalog makes Hive metadata available to users of other Hadoop tools like Pig, MapReduce and Hive. It provides connectors for...
2014-02-11
1,320 reads
My Experience Aboard SQL Cruise 2014
Where do I begin? First let me say, WOW what an experience!
How it All Began
When I first heard about SQL...
2014-02-11
1,375 reads
2014-02-11
174 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers