Thumbs up on that.  That...

Thanks for the quick reply Jeff!

Do you use Auto update stats? And for critical tables full scan with norecompute? And update these weekly? Or just full scan all stats...

I rebuild stats once per week.  Because most of the clustered indexes are "ever increasing" in nature, I use the "if it moved, shoot it" approach.  I also use full...

First, that's an insanely expensive server and you good folks have crippled it with 150GB of RAM.  You...

@ Steve and @ Jonathan,

There is no question at all in my mind that the smart company will invest in it's employees.  That's not the issue I'm speaking of.

My bitching...

I see many people that site things like a lack of training at work, etc, etc.

Tell me... if you have a degree, who paid for it?  How did you get...

I'm actually not too concerned about opening xlsx files, as they can't contain executable code (as far as I know). I downloaded and virus-scanned this one before I opened...

Just to emphasize what Jeffrey Williams is talking about...

    SET LANGUAGE ENGLISH;
 SELECT English = CAST('2025-09-06' AS DATETIME);

    SET LANGUAGE FRENCH;
...

I...

Sounds really good! I have never used SQL Prompt for this purpose but used it for other, mostly code formatting and best practices suggestions purposes.

QUESTION: is SQL PROMPT...

I'm still waiting for Scott to backup his claim with a link.

No.

1. What I said was that Scalar and mTVF functions both use BEGIN/END in...

I have 1 record(1row*2columns) from 1 select

and

a different select which can result in multiple rows but will always have 3 columns.

How can I repeat the 1 row next to...

Great points. I wasn't even thinking about that at all. Happily, I haven't received so much as a finger wag for dropping the ball. I mean, Steve is going...

Does you code actually look like what you posted?  I ask because there is no space between the terms "SET" and "Processed_Flag" and there needs to be.