Hortonworks Makes HDP 2.0 for Windows Server Generally Available
Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2.0 for Windows. This is the next release...
2014-02-02
329 reads
Blog Posts
Master Data Services for the Beginner Part 06
Introduction
The consumers of our data wish to be able to make stock and financial decisions from our data. Turning raw...
2014-02-02
1,802 reads
SQL Server Analysis Services – SSAS Fundamentals
SQL Server Analysis Services (SSAS) Fundamentals
SSAS comes with your purchase of Microsoft’s SQL Server. It is a separate component and...
2014-02-02
3,206 reads
Transactions: Creating a single restore point across multiple databases.
This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...
2014-02-02
1,382 reads
Dating Tips Part 1
This is the first in a series of dating tips, so if you need you’ve come to the right place.
...
2014-02-01
263 reads
Master Data Services for the Beginner Part 05
Introduction
In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data. Today...
2014-02-01
1,904 reads
Some Great Big Data Sources
What kinds of data are exciting to you? Census and government data? Zombie Data? Marvel Comics? Time and time again...
2014-02-01
191 reads
Famous Move Quotes–Visualized
Ran across this poster of movie quotes – $20 will get you a copy. Why might you be interested? The visualizations...
2014-01-31
1,229 reads
Friday Followup For January 31, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-01-31
1,124 reads
Honored to be added to SQLRockstar’s SQL Server blog rankings
Today I woke up to find that Thomas LaRock (blog | twitter | linkedin) has added me to his SQL Server Blogger...
2014-01-31
1,220 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