Introducing Kalen Delaney’s SQL Server Stairways Tutorial Series
In case you haven’t noticed, there is a new link on SQLServerCentral.com for a new series of tutorial articles called...
2011-02-16
1,118 reads
PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations that are well under way. Time has come again...
2011-02-16
7 reads
PASS Summit Volunteers Needed
Well, we are coming around into a new year. With this new year there is once again PASS Summit preparations...
2011-02-16
629 reads
How To: Load Dimension Tables with Integration Services - Introduction
When I first started down the business intelligence and data warehousing road, I needed to learn the foundations of dimensional...
2011-02-16
1,350 reads
February 2011 JSSUG Meeting Tomorrow
Tomorrow, I will be presenting at the Jacksonville SQL Server Users Group (JSSUG) meeting. Please join me for my talk...
2011-02-16
432 reads
SQL Rally Performance Tuning SSAS Session
Last week the final sessions for SQL Rally were announced, and I was very excited to find out my Performance Tuning...
2011-02-16
1,238 reads
MagicPASS February 2011 Meeting
If you're in the central Florida area you're invited to the February 2011 meeting of MagicPASS, South Orlando's SQL Server...
2011-02-15
538 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that he’s not the origin of it. Whoever said it had...
2011-02-15
13 reads
Book Review: The Lazy Project Manager
“There is nothing more uncommon than common sense.” Some attribute the axiom to Frank Lloyd Wright but others are adamant that...
2011-02-15
834 reads
DWH Workshop material
As announced in my DWH workshop in Munich, you can find here my
whole ETL solution. Thanks for attending my workshop...
2011-02-15
798 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