MCM Prep – Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
790 reads
SSMS addin (and wrapper)
So I mentioned I'd been working on an SSMS addin. What I didn't mention was that I've also been working...
2011-01-04
1,416 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
769 reads
The Best Database Administrators Automate Everything
Do you understand the value of your time? I mean really understand it. Time is your absolute number one most valuable asset. Once...
2011-01-04
1,428 reads
Invitation to T-SQL Tuesday #014
Hello and welcome to the first T-SQL Tuesday of 2011!
2010 was a great year for T-SQL Tuesdays, dreamed up and...
2011-01-04
1,303 reads
MCM Live Blog – Week January 3
Watching videos?! Su-ure!
Surprisingly it’s now my fourth week of blogging about the things that I’m doing to study for the...
2011-01-04
274 reads
MCM Prep - Only ONE Transaction Log File
Unlike for data files, SQL Server does not use multiple files for the transaction log in any way that improves...
2011-01-04
781 reads
My 2010 Year in Review
While in Cincinnati for the first time since September of 2007, I heard on several occasions that I work too...
2011-01-04
404 reads
31 Days of SSIS – Data Flow Breakpoints?! (3/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. In yesterday’s post I...
2011-01-04
546 reads
Lots of Intel Sandy Bridge News Today
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information...
2011-01-03
859 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