How to Performance Tune a VLDB on your Desktop
Recently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to...
2010-08-17
931 reads
Recently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to...
2010-08-17
931 reads
Where can you spend $100 and get three full days of technical training? devLINK of course. devLINK 2010 was held...
2010-08-08
512 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-08-02
607 reads
This month’s question of the month was:
Tell us your story of how you happened to become a DBA.
This month, the...
2010-08-02
384 reads
While I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not...
2010-07-27
1,059 reads
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-27
3,072 reads
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-21
3,379 reads
The SQL Server DMV Starter Pack is a free eBook (84 pages) that describes 28 different ways that DMVs can...
2010-07-20
4,906 reads
Red Gate Software has recently opened up its SQL Response v2 Early Release Program (EAP), and is inviting anyone who...
2010-07-17
964 reads
November will be a busy time of the year for many SQL Server DBAs as they head off to the...
2010-07-14
676 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