Database Maintenance
I often see a request for some scripts to help with database maintenance. Sometimes those questions come in the form...
2011-03-09
1,043 reads
T-SQL Tuesday #016 – Aggregation
It’s that time of month again, time for Adam Machanic’s (Twitter | Blog) T-SQL Tuesday blog party. This month the party...
2011-03-09
817 reads
Rocky Mountain Tech Trifecta v3.0 Keynote
I had the main room keynote at the recent Rocky Mountain Tech Trifecta v3.0 in Denver. Jeff Certain & Ben Hoelting...
2011-03-09
1,015 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
8 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over 300 attendees watching five tracks of local speakers...
2011-03-09
12 reads
SQL Saturday 67 Chicago Pre-con Double Down
Yes, this looks familiar. Didn’t I write this last week? Well it’s new and the same. We have another pre-con available on the Friday, 3/25, before SQL Saturday 67....
2011-03-09
14 reads
SQL Saturday 67 Chicago Pre-con Double Down
Yes, this looks familiar. Didn’t I write this last week? Well it’s new and the same. We have another pre-con...
2011-03-09
965 reads
Say Hi to the Dimension Merge SCD Component
Last week was a great week all around. It started with Canada's first SQL Saturday in Vancouver - packed with over...
2011-03-09
1,038 reads
[OFF-TOPIC] Make a difference
I follow the blog of Johnny Long (twitter) from time-to-time, especially as he chronicled his work in Uganda. I know...
2011-03-09
806 reads
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
Related Posts:
T-SQL Tuesday 109: Influence Somebody Invite December 4, 2018
T-SQL Tuesday Participation Over the...
2011-03-08
9 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
Alamat Kantor BCA KCU Subang Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa...
Alamat Kantor BCA KCU Purwakarta Telp:08218154374
Hub Via Wa:628218154374 Alamat Bank Bca Kcu Purwakarta, Jl. Jendral Sudirman No.85, Nagri Tengah,...
Alamat BCA KCU Soekarno Hatta Telp:08218154374
Hub Via Wa:628218154374 Alamat Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung,...
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