As far as I know, there is no way to do that. The best solution I know of is to make a new folder and push the files over manually...

If it is "results to screen", it is more likely the rendering on screen that is the slowness and not the data retrieval/download process and in that case, an indexed...

ALSO I am not saying "don't use indexed views", I am saying test it. Even just adding 1 index will impact INSERT, UPDATE, and DELETE performance (and can impact SELECT...

Just a heads up about indexed views - in SQL Server Standard, indexed views must be explicitly requested to use the index. In enterprise the query optimizer will use the...

Just wanted to add, I liked the article. I wasn't trying to criticize it, especially since I've never had the guts to post one on here. I just wanted clarification...

Another thing that ties into what Grant said - if this is SSIS, those 22M rows are likely trying to be stored in memory. If you don't have enough memory...

I am slightly confused by the last example - Integrating NTILE with RANK(), DENSE_RANK(), LAG(), and LEAD(). You have both LAG and LEAD partitioned by EmployeeId and EmployeeID is unique...

Another thing it COULD be is do you have that excel file open in any other tool (Excel for example)? If it is on a shared drive, is the excel...

Good advice... do something out of my comfort zone... RELEASE DIRECTLY TO PROD!!!

Just kidding. My goal is to get back into photography. I kind of dropped out of that for...

Stepping away from TLS being the issue, can you run the isql command with the -v parameter? This will give you verbose output and will tell you EXACTLY what is...

Cyrusbaratt, I am a bit confused why you say that monitoring tools slow things down then suggest Idera, which is a 3rd party monitoring tool (plus a ton of other...

Is that the only error? USUALLY an "unable to connect" is followed by some information about a login issue or a cannot find the host or something along those lines.

BUT...

Wanted to throw my hat into the ring on this - I have done both. In-place upgrades and migration upgrades. My biggest factor in deciding the method is "how many...

No can do in SQL Server according to the docs: https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Those state we have 1024 columns max in a table.

You'll need to break it up into multiple tables; probably want...

As a random thought, are you fully patched on both SSRS and SQL Server?

Also, when you uninstalled Standard, did you reboot after the uninstalls? And did you reboot after the...