Feedback on My Abstracts
Here’s the raw feedback from my submissions for the Summit. To those who wrote the feedback for me (and all...
2014-07-03
712 reads
SQLAndy
The Selection Process
According to this post from Amy Lewis (PASS Board of Directors) there were 943 abstracts submitted for the 2014 PASS...
2014-07-02
574 reads
The Case Of the Downward Pointing Arrow-Question of the Day
The Case Of the Downward Pointing Arrow is written as an abbreviated mystery, Sherlock Holmes style. Had to laugh at...
2014-07-02
442 reads
Above Reproach
It’s been a busy few weeks in the world of PASS, lots of good conversations that I’ve followed with interest,...
2014-07-02
872 reads
Speaking at ONETUG on July 10, 2014
I’ll be presenting SQL Server Performance for Developers to the members of the Orlando .Net User Group (ONETUG) on July...
2014-07-02
483 reads
A Deeply Planted Seed-Question of the Day
Another trivia question today, this one about figuring out which of the options provided has a particular negative identity seed....
2014-07-01
302 reads
SSC Editorial: The Product Centric Career
The Product Centric Career is my latest editorial for SQLServerCentral, this one from the perspective of my own career and...
2014-06-30
1,152 reads
Building The SQLSaturday Orlando Marketing Plan-Part 21
Been busy the past week, not as much time on this as I’d have liked:
Received the “retro” flyer with the...
2014-06-27
1,136 reads
What is 268435456?
What is 268435456? is the Friday question of the day. It’s a trivia question, but maybe an interesting one for...
2014-06-27
1,324 reads
The Great Escape-Question of The Day
The Great Escape is the question today, one I think you will like because…it’s about LIKE! It’s a head scratcher....
2014-06-25
558 reads
Blogs
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...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
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