The example posted is the beginning of a RBAR trigger.  INSERTs in SQL Server will fire the trigger only once per INSERT even if the INSERT inserts thousands of rows. ...

Does this mean that, ultimately, the new code will go essentially directly from the Developer to Prod without going through QA and UAT.  If so, that's a really, really bad...

We get a bunch of tasks/requests to run t-sql scripts to update views or stored procs or bad data.

Does anyone know of a server product that can automate the...

And this is why we want posters to always put the DDL for their tables where we can see them. After 30+ years of doing SQL and RDBMS, I...

I am assuming that the foobars have a key made of the foo_description in the foo_id.

SELECT foobar_id

FROM Foobars

WHERE foobar_description IN ( 'Apex', 'Bill', 'Sierra' )

GROUP BY foobar_id

HAVING COUNT (*)...

I have to ask "Why" here.  What is...

It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

As to your "access denied" error, where...

Meeting customers' needs. That's all I want.

Any technology push stinks. And resume building is detestable.

We are here to serve. If we can't relate our activities to a specific customer...

Heh.. Ok... So, you're satisfied with...

That's probably ok but the sys schema needs "love" as well. 😀

Attached.  Again, I'm very aggressive in the code.  If the RowModCtr > 0, then I rebuild the stats.  You can certain modify that based on...

Ugh!  Shrinking.  It does "index inversion", which is one form of fragmentation that really does hammer performance into the ground.  That's why I use the "Swap'n'Drop" method on a lot...

It doesn't close any "security hole".  Only the people that can enable it can use it.  Turning it off won't prevent that.

As to your "access denied" error, where is the...

+1000!

If their plan fails, they can always go back to tipping Dogecoin or peddling courses on how to get rich quick by buying cheap stuff on AliBaba and reselling...