How To Recondition Batteries
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
47 reads
These days we are all looking for ways to save money and even to help the
environment. If you came across this site you are most...
2018-04-24
47 reads
The Southwest Missouri SQL Server Users Group (SWMOSSUG) is dedicated to providing SQL Server Education and Career Guidance for IT...
2012-08-29
1,814 reads
I have been told by hundreds of DBAs that I have the best DBA job in the world as Director...
2012-08-15
1,111 reads
I think all of us have had poor, good, and great managers at one time or another in our career....
2012-07-02
1,943 reads
Reprinted from my editorial in the Simple-Talk Newsletter.
It’s hard to believe, but it was five years ago that Red Gate Software...
2012-06-18 (first published: 2012-06-11)
2,050 reads
When I was a novice DBA, I spent little time documenting my SQL Servers. But as I became more experienced,...
2012-06-12 (first published: 2012-06-05)
4,753 reads
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,037 reads
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,789 reads
As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...
2012-05-24 (first published: 2012-05-21)
2,190 reads
Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...
2012-05-21
4,329 reads
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
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