2018-05-17
123 reads
Ben Kubicek
- Interests: Jesus, playing guitar singing, most sports, running, biking, triathlons
How do you deal with disappointment?
Disappointment is hard, but you get to choose how you react to it.
2018-05-14
122 reads
SQL Server Authenticated Users, why are we still using them?
AD Authentication in SQL Server has been around for a long time, so why do we still use SQL Authentication?
2018-03-30
429 reads
2018-02-01
95 reads
Is the old stuff worth learning?
Often we are encouraged to learn the latest things, but sometimes the old stuff is worth knowing too.
2017-12-26
91 reads
2017-12-18
69 reads
2017-12-11
91 reads
Holiday parties: Do you love them or hate them?
It is getting to be that time of year. Holiday parties are you for them or against
2017-11-14
81 reads
Introverted vs Extroverted
A lot of us are introverted, so is there anything that can be done about it?
2017-11-09
129 reads
2017-11-01
103 reads
Blogs
T-SQL Tuesday #201 - Temp Tables, Friend or Foe?
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
Forums
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
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
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