I found out why the flag was set. This was a message from Microsoft.

Cause:

Your server encountered a non-yielding scheduler and this caused a stack dump on the primary node, which...

Thanks Kevin and Gail for the information.

Thanks,

MC

Ok folks, I think I am losing my mind. Now, I am unable to recreate the situation. Thanks all for looking into this and I am so sorry for letting...

I am...

Thanks Igor for the reply. I noticed the differences as well and this is where I need help and a bit confused. Does this mean that SQL is using different...

I normally do not use the Query Designer. I am only using it because I am in the process of moving an Access database to SQL and was looking for...

Both queries returned the same number of records (136458). I captured the actual execution plan of both queries as well. At a quick glance, they both look identical. Files attached....

Thanks all for the advice and suggestions. I just have to convince the application owner that adding the index is the right way to go.

Thanks,

MC

Drew,

I like your solution better. It is short and clean.

Thanks,

MC

Try this, using a combination of a tally table and a lookup table.

SELECT TOP 10000

IDENTITY(INT,1,1) AS N

INTO #Tally

...

Thanks all for the suggestions. I used N'DY1' DayNo and the warning went away.

Thanks,

MC

Thanks Hugo. In my case, I am moving on because it does not affect the result of my query. I was just trying to clean things up.

Thanks,

MC.