SQLRally Session Voting Schedule Change
Jack Corbett posted the official announcement to his blog - I'm posting here as well to make sure we reach as...
2011-01-04
365 reads
PASS SQLRally Update–Voting Pushed Back
In our original plan for PASS SQLRally we had set this week as the week to start voting for sessions. Unfortunately we are having to push back the voting...
2011-01-04
7 reads
31 Days of SSIS – Folder Structures (4/31)
31 Days of SSIS
Hopefully by now you’ve read the introductory post for the 31 Days of SSIS series that I...
2011-01-04
433 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other two books earlier in the year in 2010 and...
2011-01-04
9 reads
MockingJay – a review
After a long wait, I have finally read the final installment in the “Hunger Games” trilogy. I read the other...
2011-01-04
582 reads
MCM Prep – Sliding the test
If you can’t cram enough for the test, what’s the thing to do? Slide the test. I realized last night...
2011-01-04
650 reads
Microsoft DreamSpark for Students
If you are a college or high school student, you can get a very valuable assortment of free software from...
2011-01-04
1,316 reads
Finding last database growth date and time
A file growth operation on a database server is a extremely expensive operation. Many Performance problems correlate to a Data...
2011-01-04
492 reads
Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,988 reads
Filling in Data Potholes Redux: Tally Tables vs CTEs
In A Previous Installment
Re-Ducks
… our heroine (that’s me) rediscovered CTEs, specifically in the recursive style. That was in my post...
2011-01-04
1,119 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