Does Your Company Have a SQL Server DR Plan?
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,554 reads
This past month I ran a poll asking this question: “Does your company have a formal, tested, disaster recovery plan...
2010-06-30
1,554 reads
This is my third in a series of checklists that I am putting together for a new book designed for...
2010-06-29
2,961 reads
As a part of a new book project, I am putting together a series of checklists that DBAs can use...
2010-06-23
1,222 reads
Starting today, you can vote for the 2010 Exceptional DBA of the Year. All of the nominations have been reviewed...
2010-06-23
470 reads
I’m in the process of putting together a SQL Server hardware inventory/audit checklist for an upcoming book project. The purpose...
2010-06-21
2,613 reads
SQLBits—The 7 Wonders of SQL Conference—will be held in York, England, September 30 through October 2, 2010. SQLBits is the...
2010-06-21
440 reads
Recently, Buck Woody challenged myself, Paul Randal, and Brent Ozar to write a blog post on “How I Travel”. I...
2010-06-18
2,349 reads
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
423 reads
While I was at TechEd last week, I got a 50% off Microsoft Certification test voucher that expires on June...
2010-06-15
1,497 reads
TechEd is finally over, and I have been overwhelmed by attending 20 different sessions over the last four days. As...
2010-06-12
441 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