SQLServerPedia Awards Winner
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am...
2010-11-15
559 reads
PASS Summit 2010-Wrap Up
Thursday ended with a ‘Meet the Board’ meeting where attendees could come ask the Board questions or present ideas. It...
2010-11-15
736 reads
David Dewitt at the PASS Summit
The PASS Summit is complete and we got what we asked for from David Dewitt. He spoke on the third...
2010-11-15
2,094 reads
Switching Off Parameter Sniffing
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,895 reads
PASS, Keynotes and Tweeting
I have never had the opportunity to go to PASS before, but even though I was unable to attend this...
2010-11-15
334 reads
The PowerShell CookBook
“A script club.” That’s what a friend of mine said when he was telling me how he’d learned the basics...
2010-11-15
451 reads
It's an Opportunity! Not an Obstacle!
Write this down… No really… Write it, print it, send it to all of your friends and loved ones. J...
2010-11-15
382 reads
ScaryDBA Blog Reboot
After all the conversations at FreeCon last week (more on that later, when I’ve assimilated it better), I finally decided...
2010-11-15
528 reads
SQLSaturday #59 - Speaker Interview Series #18 with Matt Van Horn
SQLSaturday #59 – Speaker Interview Series #18 – with Matt Van Horn
Notes from the SQLSat#59 Team: SQLSaturday#59 is just 5 days away...
2010-11-15
915 reads
Career Advice – Play Your Own Game
I get asked this question fairly often. How do I find time to write so much, work on SQL Server,...
2010-11-15
1,001 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