A SQL Azure Customer
Not me, though I’m not necessarily against Azure in principle. I had a friend ask me for a SQL Server...
2011-01-26
738 reads
SQLSaturday 57 In Houston, Here I Come!
Another year and staring it off right! I’ll be speaking at SQLSaturday in Houston, TX on the fundamentals of storage...
2011-01-26
946 reads
User Group Giveaway: My Latest Book
As I annouced earlier, Oracle and database expert, Bert Scalzo and I collaborated on an introductory text appropriately titled Introduction to SQL...
2011-01-26
706 reads
Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
554 reads
Presenting on #SSIS to EDMPASS Today
Will you be in Edmonton today? How about near a computer connected to the inter-tubes? If so, you might be...
2011-01-26
790 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not run of the mill training, but it...
2011-01-26
10 reads
Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not...
2011-01-26
977 reads
SQL Saturday #71: Call For Speakers
The SQL Saturday #71/New England Data Camp #3 call for speakers has been open for quite a while. But, we...
2011-01-26
1,030 reads
31 Days of SSIS – One Package, Unlimited Tables (25/31)
31 Days of SSIS
One day at a time and we have reached the twenty-fifth post in the 31 Days of...
2011-01-26
1,714 reads
The Lost Hero – A review
With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy ahead of them. I just finished the first installment...
2011-01-25
7 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
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...
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