The real main problem is that in America and Europe everyone is so f****g smart!

everyone knows everything about viruses, and about corona viruses in particular. Everyone knows everything about masks...

Instead of

INSERT INTO [dbo].[DTable] SELECT @m,@D,@F,@T,@Q,@R,@RR,@IO

UPDATE [dbo].[DTable] SET [RR] = @T - 7 where @Q = 1

Should it be

INSERT INTO [dbo].[DTable]

SELECT @m,@D,@F,@T,@Q,@R,case when @Q=1 then @T-7...

 SELECT 
t2.trans_id
MAX(CASE WHEN t3.dir = 'dir1' THEN t3.dir ELSE Null END ) AS flag_dir1,
MAX(CASE WHEN t3.dir = 'dir2' THEN t3.dir ELSE Null END ) AS flag_dir2
FROM t2...

Say you have a 10GB table with 1 clus and 14 nonclus indexes, each with 1 column.  You "tell" SQL to rebuild ALL indexes.  Would SQL scan the table...

Can you please show the definition of that PK_EmployeeJobHistory_1?

and probably of the other indexes too?

On such tables indexes should never require defragmenting/rebuilding.

If you need rebuilding indexes it’s probably a good time to rethink the indexing strategy.

you need to figure out what causes fragmentation and redefine the indexes in such a way...

How about "This string is a space separated string"?

will this function work?

You're absolutely right about sarcasm.

And that what I was hoping to be "punished" for by more educated members.

Without any sarcasm this time.

Actually, I was really hoping someone will show where I was wrong in that statement. Otherwise... it’s too sad to realise the truth.

Think about it: they consider xp_cmdshell is a security risk, and SolarWinds is not.

Go figure.

Not to mention PowerShell - administrative scripts requiring ultimate access rights are executed by a sysadmin...

@Jeffrey Williams

Actually this is an SSIS solution consisting of 10 packages run by a master package. The functionality currently in place is Truncate and ReLoad of staging tables from...

I'd suggest having a job running through all 15 servers, identifying such sysadmin users left behind and sending out a notification with details of such users, if found.

But altering the...

Sadly there's only a fillfactor (i.e. rebuild factor) rather than a "loadfactor" which would leave the original page with nn% of free space as the page was initially being...

LEFT JOIN Period_Ref SD ON I.Support_Start_Date = SD.START_DATE

LEFT JOIN Period_Ref ED ON SD.START_DATE IS NULL AND I.Support_END_Date = ED.END_DATE

You must be using some dynamic SQL for the process, and that dynamic script is built incorrectly.

This is the part you need to fix.