SQL Math: Whole Numbers, Real Numbers
It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no...
2011-03-28
1,881 reads
SQL in the City – The Red Gate Tour
Red Gate Software is announcing SQL in the City today, a series of events that will bring a free day...
2011-03-28
1,459 reads
Torn page detection vs Page Checksum
TornPage Detection: Up to sql server 2000, for data corruption process is called torn page detection, this option is default on. The...
2011-03-28
910 reads
Tip on Speaking (and Writing) Well – The Key Idea
Cross-posted from the Goal Keeping DBA blog:
In the September 2010 issue of Toastmaster magazine there’s a great article by Chris...
2011-03-28
1,287 reads
5 Days to Outstanding DBA Customer Service
Outstanding Customer Service in 5 days
Your success as a Data Professional is directly dependant to the quality of service you...
2011-03-27
667 reads
SQL Server Crossword #3 – Solution
Here’s the solution to SQL Server Crossword #3.
I hope you enjoyed it. Let me know if you would like me...
2011-03-27
1,022 reads
Cluster failover – what’s the best way to get notified?
G’day,
I look after several clustered instances of SQL SERVER. One of the tasks that I do every morning is to check...
2011-03-27
2,836 reads
Designing Reports with Custom MDX Queries – part 1
This article is the first in a three-part series
On the Microsoft Developer Network (MSDN) forum for Reporting Services and other...
2011-03-27
1,376 reads
Index Black Ops Series
Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats. The series investigates how the...
2011-03-26
855 reads
DevWeek 2011 – Day 1
Unfortunately, I couldn’t be in two places at one time, there were two tracks dedicated to the SQL Server DBA...
2011-03-25
722 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