My Surprise MVP Party
Two Fridays ago, Sean and I sat down for our weekly DBAs@Midnight webshow* as usual. Unusually, we were expecting an out-of-town...
2011-01-24
584 reads
RTFM365, Week 7
[Commence whine-a-thon, thinly veiled as an introductory paragraph to a blog.]
As I knew it would, it is getting VERY difficult...
2011-01-24
490 reads
SQLskills Master Immersion Events 2011 competition
AdvertisementsSQLskills Master Immersion Events 2011 competition
I have completed engineering and my native is M.Uthamasolagan (village near chidambaram ). I have...
2011-01-24
630 reads
Coming to SQL Saturday #60 in Cleveland
It’s just a couple weeks away, on Super Bowl weekend. I can’t believe this is event #60, still in shock...
2011-01-24
819 reads
Corrupting Databases for Dummies- Hex Editor Edition
Corruption is so ugly it gets a lolworm instead of a lolcat.
Let’s make one thing clear from the start:
This Post...
2011-01-24
2,624 reads
Ebooks: Deal of the Day
Apress, as I expect you know, publish some really good SQL Server books. Some of which are on the MCM...
2011-01-24
627 reads
Microsoft SQL Server Licensing For Dummies..
Microsoft SQL Server Licensing For Dummies..
Don’t let the above title fool you! Have you been confused on the Microsoft...
2011-01-24
89,603 reads
Keeping Perspective: What Are You Building?
Think about your responsibilities at work for a minute. How many do you have? Can you even name them all?
As technical professionals,...
2011-01-24
699 reads
The Danger of Agreements
I'm speaking in context of Getting Things Done, not a legal or contractual agreement. What brought this up is me...
2011-01-24
804 reads
SQL Saturday #70 - Columbia, SC - Call for Speakers
We're gearing up the advertising for SQL Saturday #70 since we're about 8 weeks out. In keeping with that, our...
2011-01-24
2,014 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