What’s gonna happen to that “sparkling new structure” after the 1st INSERT statement executed the next morning? Will it be still as sparkling?

what about 2nd insert? Will 1st one have...

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 else @RR end,@IO

 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