Work Isn’t the Most Important Thing
I had quite an adventure today, away from work. We had a pipe freeze in the house, a sick kid,...
2011-02-02
1,091 reads
February Question: Share with us your “best” restore disaster stories.
As DBAs, making backups and restoring data is one of the foundational skills we all must master. But sometimes things...
2011-02-01
453 reads
This Month… SSWUG Free SSIS Expo
Stinking Feet?
A couple months back I mentioned the SSWUG Free Expo Event: Basic and Complex SSIS Features. The time has...
2011-02-01
432 reads
Is a clustered index best for range queries?
I see a lot of advice that talks about the clustered index been the best index for use for range...
2011-02-01
1,742 reads
PASS Update #51-Summit Site Selection
In November/December HQ requested that the Board to send in suggestions for possible sites for the 2013 PASS Summit. I...
2011-02-01
1,566 reads
SQL Rally BI Sessions
This week the voting for the SQL Rally BI track went out, and I wanted to send a quick reminder...
2011-02-01
1,196 reads
24 Hours of PASS Sessions Announced
In case you missed it last week, PASS has announced the speaker lineup for the next 24 Hours of PASS. ...
2011-02-01
567 reads
What’s a Passive Server?
Licensing software is often a more complicated process than I think it should be. Licensing database software seems to be...
2011-02-01
5,174 reads
31 Days of SSIS – SSIS Naming Conventions (31/31)
31 Days of SSIS
We’re at the thirty-first, and last, post for the 31 Days of SSIS. The series started with...
2011-02-01
1,449 reads
Your Lack of Documentation is Costing You More Than You Think
You’ve got a mountain of work to get done and not enough time to do it in. There’s simply just not...
2011-02-01
1,514 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
Alamat Kantor BCA KCU Bekasi Telp:08217555651
Hub Via Wa:628217555651 Alamat Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel.,...
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
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