David... I thought that fighting tooth'n'nail to get something done right was "normal", especially since it wasn't their idea.  And, because it wasn't their idea, they might try to kill...

Nicely written, Nisarg .  And the annotations in the screen shots are helpful and also nicely done.

Ah.  Totally get that.  I'm thinking that they don't actually have a good backup, though and that this is "one of those times".  But, good point.

The "best" way is to anticipate the next question that usually comes...

Ok, so the code that's causing the performance problem...

Just to be clear, the reason I suggested going to the SIMPLE Recovery Model in my example was to, in fact, break the Log File chain in an...

Yes.  Your original post stated...

My personal feeling is that you're looking at the...

I wouldn't wholesale reduce, leave, or raise spending. I'd be more judicious about where I did any of those.

I also would look to incentivize others to find ways to...

Just to be clear, the reason I suggested going to the SIMPLE Recovery Model in my example was to, in fact, break the Log File chain in an attempt to...

As I know, freelancers in that field don't struggle with lack of work, they're always in demand, so you shouldn't have any problems with that regarding the number of...

I think the word "innovation" is a buzzword, the meaning of which has been bastardized just as the meaning of the title of "DBA" and the real "DevOps" has become.

What's...

"Shoddy" is the correct term for the rounding of the SMALLDATETIME datatype.

 SELECT CONVERT(SMALLDATETIME,'31 Dec 2022 23:59:30.000');

Result... next day, week, month, and year.

May 10, 2023 at 2:26 pm

#4187425

My apologies... I don't use any of the things that use the log file of a database so I don't actually know what else to check on this issue.  My...

If partitioning IS present, why is there a need for any of this?  SWITCH the old data out.  Copy it to a new table in the archive.  Then SWITCH that...

I will want to have this solution in my arsenal. What is the code to install ACE Drivers? How do I set it up?

Please, show me easy and step...