It’s A Major Award!
“It’s a major award!” That’s what Darren McGavin’s signature role, Mr. Parker, proudly proclaimed to friends and family in the...
2011-01-07
592 reads
The laptop rebuild continues
Not done yet, but I have been slowly patching and installing software over the last few evenings, stuck at my...
2011-01-07
664 reads
SQL Server Index Tuning for Mere Mortals
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
2011-01-07
3,477 reads
PASSMN January Meeting Update
Thought I would drop a quick note on the January PASSMN meeting. We’re running a bit behind getting things ramped...
2011-01-06
486 reads
SQLSaturday #62 - Tampa
Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa. If you haven't...
2011-01-06
649 reads
31 Days of SSIS – Recursive SSIS Package (6/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In the first post...
2011-01-06
2,562 reads
Date Rounding Tactics and the Tiny Devil of SMALLDATETIME
Tiny Devils
With every new year I think a little bit about time and dates. This posts looks a little more...
2011-01-06
2,417 reads
Goals for 2011
Last week I wrote about my goals for last year and some frustration at having to make some trade offs...
2011-01-06
581 reads
Fun with a String
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that he had 2 tables. Table 1 has numeric key...
2011-01-06
10 reads
Denali is coming…..
SQL Server 11 (code-named “Denali”)
Heres the official MS speak:-
Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in...
2011-01-06
464 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