are you querying cross domain ? ( add the domain extention ! )

I have to scan a bunch of servers for failed logins. As part of this process, I want to get the incoming host names. However, the SQL log file...

Thank you for the...

Start with avoinding functions in where clauses ! ( needs full ( index ) conversion before actual use )

Declare @RefTs datetime2(0) = dateadd(MM, datediff(MM, 0, GETDATE()) -...

Can this ref be applicable for your issue?

gMSA account authentication failure during password rotation

spid -2 is supposed to be an orphaned DTC transaction.

ref: Disaster recovery 101: dealing with negative SPIDS (-2 and -3)

Johan, you would need to check with the vendor, but I don't belive that performance improvements are the core reason. I belive that for some special purposethey choose KS+WS...

It is indeed scheduled in the weekend (using SQLAgent and Powershell).

Still 23 minutes is a long time to collect these statistics for this single database.

It's a good thing not all...

Currently we are collecting database statistics information using

select * FROM sys.dm_db_index_physical_stats( 14, NULL, NULL, NULL, 'SAMPLED')

For some larger databases this statement takes more than