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
Capturing the Execution Plan
One last post on execution plans and Profiler (at least for now)
When trying to check a query’s execution plan, the...
2011-01-04
1,396 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. ...
2011-01-04
374 reads
XQuery for the Non-Expert – Binary Values
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-01-04
705 reads
Schedule Posted for SQLSaturday #62 in Tampa
The schedule is posted for SQLSaturday #62 coming to Tampa on January 15, 2011. I don’t have a presentation on...
2011-01-04
557 reads
Making an Operations Manager Module
Operations Manager 2007 R2 ships with Operations Manager Shell which is simply a provider with associated cmdlets for working with...
2011-01-04
860 reads
My 2011 Aspirations
Yesterday, I posted a blog about my year in review for 2010. So, I thought that it would be a...
2011-01-04
444 reads
Blogs
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
A Guatemalan's Guide to Drinking Coffee Properly
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
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
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