SQLSaturday #62 - Tampa
Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa. If you haven't...
2011-01-06
649 reads
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
2011-01-06
2,562 reads
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-06
2,417 reads
Goals for 2011
Last week I wrote about my goals for last year and some frustration at having to make some trade offs...
2011-01-06
581 reads
Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
10 reads
Denali is coming…..
SQL Server 11 (code-named “Denali”)
Heres the official MS speak:-
Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in...
2011-01-06
464 reads
Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that...
2011-01-06
1,058 reads
Rebuilding the W510 – DVD Driver Issues with x64
I backed up my machine, copied a bunch of data to both a thumb drive as well as the second...
2011-01-06
754 reads
Free e-books
I had stumbled across the free(!) Microsoft SQL Server 2008 R2 ebook, but I was also pointed in the direction...
2011-01-05
746 reads
SQL Server 2005 SP 4
Finally, after SQL Server 2005 SP3 was released Dec 2008, SP4 is now available for download.
To download visit Microsofts Download...
2011-01-05
671 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