October Question: Tell us about your favorite experience as a participant in the SQL Server community.
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-05
1,313 reads
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-05
1,313 reads
In this blog post, I continue my series of SQL Server Health Checklists that I am developing for a new...
2010-10-04
3,614 reads
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-01
1,362 reads
In my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers....
2010-09-20
905 reads
This editorial was originally published in the Simple-Talk newsletter.
Imagine for a moment if you will. As a DBA, and as...
2010-09-18
560 reads
In this post, I continue my checklist series that will eventually become a new book. The focus of this checklist...
2010-09-14
1,664 reads
Steve Jones, SQL Server MVP and editor of SQLServerCentral.com, will be hosting a free webinar with Jeff Aven, the head...
2010-09-09
715 reads
This is the third and last in a series of interviews with speakers presenting at the SQLServerCentral.com track at SQL...
2010-09-08
804 reads
This is reprinted from my editorial in Database Weekly.
During some recent conversations, I’ve noticed an increasing tendency for people to...
2010-09-07
555 reads
Brad worries that with the advent and growth of social media, has come an increasing concern that today's private conversation may turn into tomorrow's world-wide Tweet.
2010-09-06
179 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