Datetimeoffset And Time Zone Awareness
I've been working a lot with the datetimeoffset data type recently so today's SQLServerCentral.com article The SQL Server 2008 Datetimeoffset...
2011-04-18
4,391 reads
April PASSMN Meeting Tomorrow
I mentioned the April PASSMN meeting the other day… well now that meeting is tomorrow. Take a chance to invest...
2011-04-18
582 reads
Powershell Day 18
Day 18 PSSnapin Powershell works with cmdlets, and cmdlets are commands from snapins. Means spanin contains group of commands. so...
2011-04-18
819 reads
SQL Azure Cost
We’ve all heard the scary stories. A developer starts testing Azure and then suddenly gets a thousand dollar bill on...
2011-04-18
1,547 reads
"What's the point?"
This is a crucial question with regards to what needs to be done. It really hit home after listening to...
2011-04-18
809 reads
A SQL Server Hardware Nugget A Day – Day 17
For Day 17 of this series, I am going to talk about Geekbench. Geekbench is a cross-platform, synthetic benchmark tool...
2011-04-18
611 reads
PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the presentation is having some fun with the old quote,...
2011-04-17
22 reads
PowerShell, the New SQL Hammer
This is my PowerShell presentation that I have given to both Chicago SQL Server User Groups. The name of the...
2011-04-17
965 reads
Powershell Day 17
Day 17 Advance Mini Shell Mini shell is a good and can be used as a replacement of management studio,...
2011-04-17
419 reads
SSMS Tips & Tricks – Registered Server Groups
Here are a couple more SSMS tricks I’ve stumbled upon recently. Both involve the functionality of registered servers. If you...
2011-04-17
1,614 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