Maybe I am a bit ignorant here, but can't Excel save as CSV? Do you really need an SSIS package to convert an Excel file to CSV?

Failing that, powershell can...

My understanding is this is often done for performance purposes. If you are on spinning disk (HDD) and the MDF + NDF are on the same disk, then the benefits...

To me it looks like your Antivirus thinks the installer is infected. If you are 100% confident that the installer is NOT infected (ie you got it from Microsoft and...

My opinion - predicting log file usage is tricky and often not a good use of resources (your time and energy). I've seen systems that have 0 transactions one hour...

Just to play devil's advocate here - be careful adding indexes. Each new index causes some data duplication on disk. So the more indexes you have, the slower your DML...

Quick guess - this is a stored procedure? If so, then the change in plan is due to change in parameters. It kind of looks like a parameter sniffing problem....

Just wanted to add in that the "working 8-4" thing is something that only happened recently as my work contract got changed. At one point, I was on call 24/7/365...

A nice read for a Saturday morning. I remember back when I started in my current department and I thought "one day, I want to be a manager like my...

What you could do then is change your SQL to include a TOP(1) and an order by FailDate DESC. Will that solve your issue?

Alternately, make your whole query a subquery...

I think the easiest way to help you is if you can:

1- provide sample data so we can run your query and get similar results

2- provide expected output

With point number...

In that case, what you are likely more interested in is the page life expectancy. How long are pages estimated to remain in memory:

https://www.sqlshack.com/page-life-expectancy-ple-in-sql-server/

The lower the number, the more memory...

I think that your "physical memory in use kb" is the number you are looking for, but even if things aren't running, stuff is in memory. SQL will keep things...

Just wanted to point out that rmeldrum indicated in their script that temp tables put the results in memory. This is not accurate. Temp tables are written to tempdb which...

My opinion - I wouldn't make changes to the core SSRS files. My reasoning - you make all your changes and make things work exactly how you want and everyone...

As a completely random guess, are you renaming the column inside PowerBI at the presentation layer?

As far as I am aware, PowerBI shouldn't be renaming columns on you.

Alternately, any chance...