Probably a silly question but is there a reason you are wanting to drop ALL clean buffers and free ALL the caches before you do your steps?  And why you...

I think that this page will help:

https://www.sqlshack.com/max-worker-threads-for-sql-server-always-on-availability-group-databases/

The link above says that for 500 databases with 1 primary, 2 secondaries, and 1 availability group your MINIMUM threads should be 1501.  The...

Something along the lines of:

string text = ex.Message;
string path = @"C:\Data\TextFiles\logFile.txt";

System.IO.File.AppendAllText(path, text);

Although, if you are "really new to C#", I would recommend reading up a bit on...

Quick google brought me to this:

https://www.linkedin.com/pulse/ssrs-2017-anonymous-authentication-problem-solved-frans-van-der-geer/

Following directions for SQL Server 2008 to configure something for SQL Server 2017 sounds like a recipe for disaster in my opinion.  The fun part...

I think the best way depends on what sort of issues you are looking for.

If it is frequent high CPU, then task manager or WMI or perfmon will tell you...

Not sure I can help, but first thing I'd do is change the C# you posted to exclude the username and password and smtp client name.  don't need people from...

If I remember right with R (it's been a while since I touched it as it isn't really related to my job), the file you create is essentially just a...

I'm a little late to this reply, but with respect to my comment about service broker - if you set it up, I'd check to make sure you are following...

As far as I know there is no way to do that nicely inside SQL.

If doing it inside SQL is a requirement, you could modify the code you are running...

Easiest way - change the division to handle when 0 may be the result.  How you handle that is up to you, but my approach would be to set it...

It includes them becuase the Prod Line is different.

Your original requirement (original post) says:

" I only want to include ME# where there are 2 different Prod Lines associated with single ME"

So...

I must be misunderstanding.  When I run the example you gave above, I get the expected output you gave above minus the Total and Grand Total values.

When I run the...

Can you provide some sample data where this happens?

Giving the text explanation  that you did, I am not able to reproduce the problem.

If I had to guess, I would say...

My understanding of the error - the particular database file has no room to shrink.  If there is 0 bytes free in that database file (or near 0), then it...

I agree with Scott and I have a question for you Ram too - how often do these jobs run?

This is relevant because if you run the jobs nightly (for...