You could try using sqlcmd instead of SSMS

Have you tried using both the -m and -f flags?

sqlserver.exe -m -f

You could try this:

Let me know if it works.

What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation. This...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them...

I would not prefix a view with tbl.  In any case I rarely use views in an OLTP environment.  I do make extensive use of them in my...

There are...

BWAAAAA-HAAAA-HAAAA-HAAAA!!!  I don't recall Itzik ever using the word TALLY in any of his code.  At least I'm not the only one that it's mis-quoting.

February 7, 2023 at 7:15 pm

#4146706

You should have just asked it "How would Jeff Moden do it" - LOL

I'm officially "dead" with ChatGPT.  It never asked me for a password when I first setup my login.  I logged out and told it I forgot my password when...

• This reply was modified 3 years, 7 months ago by Jonathan AC Roberts. Reason: added final answer

I just tried pasting the entire question, including the "Hi"...

So it would seem!  Thanks, Jonathan.  I'll check later for things like CPU, Reads, Parallelism, and what happens with different indexes.

I take it that the PK you used was...

You're saving me lot's of time, Jonathan.  What are the conclusions of your tests?

p.s. I...

Here is something to set up about 500k rows of test data

If (OBJECT_ID('tempdb..#tbSourceData') is not null) Drop Table #tbSourceData;
--Create Table #tbSourceData (EventId int, EventStatus varchar(20), RowNum int,...

Or maybe even using LEAD: