Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...
2019-03-24
203 reads
New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....
2019-03-23
396 reads
2019-03-23
379 reads
I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...
2019-03-22 (first published: 2019-03-11)
2,384 reads
Traveling in today’s age of technology is a lot easier than in the past. You can start your journey in...
2019-03-22 (first published: 2019-03-08)
1,999 reads
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
472 reads
I’m working the first section of a basic administration course, and the first part of this is installing SQL Server...
2019-03-22
482 reads
I was working on another post when I found myself needing to dump out query results to a grid format...
2019-03-22
721 reads
Change detection is a critical component of any system that moves data from one structure to another. Most data movement...
2019-03-22
401 reads
Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the...
2019-03-22
14 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