Test Cluster Delivered & Ready to Assemble
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with...
2010-07-13
563 reads
I finally received all the components of my SQL Server test cluster (pictured left), which includes:
–One PowerVault MD3000 DAS with...
2010-07-13
563 reads
I get a lot of emails from people who read my blog, books, articles, and from people who have attended...
2010-07-12
507 reads
Originally published in the Database Weekly newsletter.
I used to work at a large organization ($8 billion in revenues) as a...
2010-07-12
412 reads
In August, I will be presenting at the following events:
DevLINK, August 5-7, 2010
How and When to Use Indexed ViewsIdentifying SQL...
2010-07-12
558 reads
Brad McGehee wonders whether DBA's should take a more active role in managing their organization's data, even if it means potentially ruffling a few feathers.
2010-07-05
286 reads
This is number four in a series of checklists that I am putting together for a new book I am...
2010-07-03
3,594 reads
Back in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This...
2010-07-03
1,116 reads
This month’s question of the month was:
What is your best advice for boosting index performance?
As usual, selecting the winning entry...
2010-07-02
438 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-07-01
458 reads
Several weeks ago I wrote a blog post called “What is the Ideal SQL Server Test Box?” At that time...
2010-07-01
1,169 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