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...

That is crazy... How would SQL Server differentiate between SQLCMD and just some arbitrary application (.NET for example)?  Set your connection string right and it would appear identical to SQL...

Possibly a dumb question but what problem are you trying to solve?  I am just trying to figure out what use case there would be to seeing when any change...

Alternately, rather than building that yourself, get a SQL monitoring and reporting tool.  The good ones will fire off an alert when a condition is met AND provide you with...

Who were the 20 people who answered "The unmasked data from the table"???

I know I am giving a hint at the answer by ruling out one of the possible answers...

Tough question for a Friday.  At the time of this message, only 24% had it correct...