"select *" asks for all data from table and thus the whole table has to be taken to Buffer Cache

assuming that both instances are on the same host,  there can...

In case of 2-members cluster, when one node doesn't see another one,  cluster decides to shutdown itself to prevent split-brain situation when you potentially have two copies of databases online...

Hi Andrey,  It turned out to be a little bit more subtle than that. I eventually traced it to the account setup.  One was set to Language =  British...

• This reply was modified 5 years, 5 months ago by  Andrey. Reason: missing verb

Aaron, i'm that you have found the root cause.

I thought about different languages, but assumed that all users on the server have the same language (usually).

Anyway, thanks for the reply....

I suspect different values of datefirst

SET DATEFIRST

https://docs.microsoft.com/en-us/sql/t-sql/statements/set-datefirst-transact-sql

however, it's better to shed light on the function code and show us what it actually does

Using 2012...

" distribution group callled "Company X PMO""

It can be also a security group in AD and not distribution list at all.

"Any ideas on what my issue is?"

I would  check OS permissions of SQL server service account.

1% of 100 is 1

1% of 1000 is 10

so, comparing only percents doesn't make much sense

In your case, I would calculate average growth speed and get undestanding when there will...

An activity makes sense if it helps to get someting desired.

You mentioned  "in relation to our needs"  but didn't describe them.

What are your needs?

then the following part of your message should be ignored, right?

"we are geeting space issues every...

I suspect, you're speaking about two different things :   dbcc jobs and maintenance (reindexing) jobs

which one affect your tempdb?

getdate() returns time also,  so in the current case not all records created 30 days ago will be deleted

to delete records by days , it's better to use cast to...

Do you mean such one?

https://www.benday.com/2015/09/10/sql-server-reporting-services-export-utility/

Studio caches data and uses it for previews.

Data is stored in .data files in the same folder where your report resides.

How to clean :  either manually  or  in automated way...

Hi, Thanks for replying. The disks are clustered, having problems with the 2nd Node seeing the disks though, validation on storage fails.  I'm looking into resolving the issues on...