MSDB Job History Duration Conversion
Have you ever queried the msdb tables to get duration details about a particular job? I’ve had to do this...
2010-10-05
2,778 reads
Converting Dates to Integers
While working on a project recently, I came across a conversion that was trying to convert a date to an...
2010-10-05
811 reads
SQLRally Event Flyer is Ready
The SQLRally marketing team put this flyer together last week. We’ll be trying to get Chapters and SQLSaturdays to link...
2010-10-04
335 reads
SQL Server Database Maintenance Checklist
In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new...
2010-10-04
3,614 reads
Slides & Samples for my SQLbits workshop & session
As announced in my SQLBits workshop & session last week in York/UK, you can find the
session/workshop material here.
Have fun!
-Klaus
2010-10-04
410 reads
Drawn By the BI Sirens
Patrick Is the lead Singer
Sirens. Their sweet songs lured sailors to their deaths in tales of yore. Alas, I too...
2010-10-04
690 reads
SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
426 reads
Return of Index Analysis
Now that I’ve finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate...
2010-10-04
447 reads
SQL Saturday in New England
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...
2010-10-04
398 reads
How to Tell if Execution Plans are Reused
I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...
2010-10-04
446 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