As a rule of thumb I use table variables like scrap paper: Write a few lines, do not depend on it, use for a small set of data only.
Say...

Seems that most developers are still writing code like done in the 90s and have not moved on in naming schemes to what Intellisense allows now. Even though Intellisense has...

This is procedural code instead of set-based code. This will work.

What I mean with this statement is you think in terms of single rows (cursor) instead of a data...

Update in batches.

Approach it with a WHILE loop that checks for the same condition your UPDATE statement uses.
If found then do an UPDATE TOP(@n).
Depending on @n...

1- In your WHILE loop use EXECUTE sp_executeSQL instead of EXEC.
Reference:  https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-executesql-transact-sql?view=sql-server-2017 
2- Capture the error from your insert statement execution
3a- If no error happened, then create...

As long as IT seems and is held to be a different part than the business any communication must fail.
IT must be part of the business and aligned to...

Personally I think auto-deleting data is a very bad idea - kind of burning the library of Alexandria. Not all data is valuable on its own however in context and...

Very nice story about white space matters.

There is unfortunately nothing from our side...

Denormalising data is not a performance enhancement.
Denormalising data is a report optimisation concept.

Imo you are asking the wrong question. If the report is run multiple times per...

Well, in Steve's case an ironed white shirt will count as costume, wouldn't it?

First off "cobbling together" a nice looking report means nothing. Artists can do that or even amateur photographers. Any business managers making conclusions on such reports (of which there are...

Long term there are two options.
Improve human society or promote inequality. Nicely described in Manna: http://www.marshallbrain.com/manna1.htm

No worries until:

- SpaceX rockets can land back on earth

- Cars drive themselves

- Elon Musk has too much money

- The Terminator comes back from the future

Oh wait, three out of...