The first time you see a new execution plan that you’re examining to fix a performance problem, something broken, whatever, you should always start by looking at the first...
2020-01-14 (first published: 2020-01-06)
533 reads
This post is to help you if you are suffering from the following issue: A VSS writer has rejected an event with error. The writer experienced a non-transient error. If...
2020-01-06
43 reads
If you’ve ever looked at the output for sys.dm_exec_sessions you may have noticed the column program_name. Frequently you’ll see entries ... Continue reading
2020-01-13 (first published: 2020-01-06)
639 reads
We’re pleased to announce the release of the Undercover Catalogue 0.4.0, (please see HERE for full details of the Catalogue). The new version brings with it a number of...
2020-01-06
31 reads
I started keeping a written record on bigger goals in life from the year 2018 – following the example set by Steve Jones and Brent Ozar. This method of...
2020-01-06
21 reads
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
4 reads
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
287 reads
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
8 reads
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
20 reads
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
122 reads
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...
My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most...
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