SQL Server PDW the Microwave of BI
The Path to the PDW
For decades we had the traditional electric oven to cook with and people thought it was...
2014-02-08
1,008 reads
Blog Posts
Friday Followup For February 7, 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-02-07
440 reads
MDX+SSAS #37–Ignore unrelated dimension or not
In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...
2014-02-07
2,545 reads
Nadella, Gates: Right Team For Microsoft? – InformationWeek
Does the pairing of Nadella and Gates foretell Microsoft’s return to glory or a new era of dysfunction? Take a...
2014-02-07
949 reads
Parent-Child SSIS Architecture
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The...
2014-02-07
2,212 reads
Reblog: January 31 to February 6
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-02-07
790 reads
Speaker of the Month, February 2014
I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...
2014-02-07
711 reads
SQL Deep Dives at Intersection in April
SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of...
2014-02-07 (first published: 2014-02-04)
1,579 reads
Top 10 Process Listing By Memory Consumption – GUI Tool
This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the...
2014-02-07
961 reads
T-SQL Tuesday #051: Place Your Bets
Place Your Bets
All bets on the table please. This is the last call for bets, no new bets will be...
2014-02-07 (first published: 2014-02-04)
2,305 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