Updating LOB does not remove old value from the storage, it creates a new one and then changes the pointer in the row of the table.

cleaning up happens on some...

Divide and conquer.

Put all the actual statements to execute into separate procedures and make the main procedure call some of them according to the flow control logic.

if @a = 0

exec...

I remember using Skype on Pentium II 350MHz computer. With pretty good sound and video quality, no stuttering or delays. That was before MS acquired it.

And after - how much...

The question is too generic. There are so many ways to achieve the expected outcome.

what did you try and what stopped you on the way?

Not gonna help.

if statistics suggest that the 1st column in the index has low selectivity, it's very unlikely that optimiser will choose to use that index.

There's a lot here.  I'm not sure I am 100% clear about what you are looking for. I will take stab at what I think I understand you are...

It seems like you use a SQL Server database as a dumb storage for the application data.

all the business logic is in the application, the data stored in the format...

Congratulations. You've learnt to choose the worst solution of them all.

How many times the query you end up with scans msdb.dbo.sysjobs?

At least 3.

vs 1 in left join.

plus unnecessary UNION ALL...

From those tables I cannot figure out - how can a user participate in more than 1 team? Is it considered an impossible situation?

Users are people who are logging...

From those tables I cannot figure out - how can a user participate in more than 1 team? Is it considered an impossible situation?

is there any connection between users and...

the problem will appear when someone creates a table named “Year[2020]”. Then your code will generate invalid SQL statements. My version handles this kind of names correctly.

This coding:

'CREATE TABLE [dbo].[R_' + @TableName + '] '

Is not bullet proof.

You may never use brackets in object names, but some people do. It's a quite effective method to keep...

It's people like you who feel the need to "gatekeep" that keeps those who are truly interested in learning more from getting anywhere. And you wonder why data-related fields...

• This reply was modified 5 years, 12 months ago by Sergiy.

Scott, you obviously don't get the concept of "no premature optimisation".

so out of touch with contemporary trends!

🙂

Is it the only thing you found there which deserve unconditional love?

You know, at some stage I stopped commenting...