First I want to say I've not used system versioned temporal tables before, but from reading about them, the below logic makes sense to me.

Step 1 though is to read...

If they are "kosher" login attempts as you say, then this sounds like users fat-fingering credentials. If this is the case, I would push back on the app writers and...

In SQL, I would avoid a loop at all costs. I would estimate that 90% (likely a lot higher) of the time you do not need a loop.

Now, my approach...

Without being in your environment, this is just guesswork, but my GUESS is that the server "Abcdef" is on a different domain than dev.com or possibly that server lost the...

Varchar(max) can hold more, but if you really need to store a huge amount of json data, it may make more sense to store it on disk and parse it...

Are you doing a reorg of all indexes followed by a rebuild of all indexes? I REALLY hope not as that is redundant.

But reasons it could be slow that come...

Probably a dumb suggestion, but do you get the error if you run the restore as sa? I KNOW you said permissions are good, but when the system gives me...

Just so I understand the issue:

LIVE system - 2 hours to do index maintenance

TEST system - 10 minutes using the backup of live that is restored nightly

TEST system - 2...

I used Dennis Jensen's code (as I could copy-paste to SSMS) then tweaked it to work in SSMS and give some results with ID and DueDate:

USE master
DECLARE...

To add to what Jeff (and you) said, I wouldn't throw technology at a problem unless you know that it is the solution. And if you don't know what the...

I am not sure what the "best" way to handle this is, but the approach we took was to set up a second job to watch for running jobs. It...

@jefferyjordan26 - my advice would be to ask that recommendation on a vdj forum not a SQL server forum. That being said, I would look at the recommended specs for...

Now that lists it as a security update but if you actually go to the download page, it is a GDR download which goes back to my previous reply.

As for...

Doing a quick google, I found this:

https://stackoverflow.com/questions/23774596/udp-client-and-server-using-ipv6

Quick read on that (it is short) is basically that the network interfaces don't support listening on both IPv4 and IPv6 at the same...

With SQL Server 2019, Microsoft doesn't release "Security Updates".  All you get are CU's or GDR's and both of these are cumulative update which includes all previous patches.  You just...