White Paper of Supportability Roadmaps
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and...
2010-11-09
681 reads
Back Home
And glad to be there. I was gone almost 7 days, home only for 24:15:00 before back out on another...
2010-11-09
819 reads
First Impressions
SELECT @@Version
Microsoft SQL Server “Denali” (CTP1) – 11.0.1103.9 (X64)
I’ve been playing with the CTP for a few days (with absolutely no...
2010-11-09
1,429 reads
Day 1 at SQLPASS Keynote Address
Microsoft announced the RTM of SQL Server 2008 R2 Parallel Data Warehouse, which will be available as an appliance in...
2010-11-09
467 reads
PASS Summit 2010-Tuesday
Started my day by going up to the club floor for the continental breakfast, met Mark Souza on the elevator...
2010-11-09
565 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap out a bit sooner. This month, I intentionally delayed...
2010-11-09
5 reads
November S3OLV Recap
Last Thursday we had the monthly meeting for our local PASS chapter. I would normally try to get the recap...
2010-11-09
502 reads
PASS Summit: Day 1 Keynote, Part 3
Ted Kummert is still talking.
For the cloud, of course, they’re talking about SQL Azure. Microsoft really is throwing themselves into...
2010-11-09
677 reads
PASS Summit: Day 1 Keynote, Part 2
Mark Souza from the SQL CAT Team, some of the smartest & most capable of MS consultants in SQL Server, is...
2010-11-09
719 reads
PASS Summit: Day 1 Keynote, Part 1
Sitting at the big kids table at the PASS Summit, ready to rock and roll. The Summit has not officially...
2010-11-09
664 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