VERY quick look at that, you have a bunch of dynamic SQL which is always a bit risky, so my opinion, I would re-write the whole thing without the dynamic...

First step, review the execution plan. Next step, I'd check server resources and server settings. If the query is slower, is the hardware identical? If not, that could be the...

slow inserts are USUALLY caused by either slow network connection between the client machine and the database OR poor indexing strategy on the table OR stored procedure for the insert...

My opinion, I'd redesign the original table to not allow varchar in the column and force ints... but if you are stuck with that, I would look at a string...

the rows affected can be removed by running the command "SET NOCOUNT ON" at the start of the SP.

As for the date/time issue, that is Excel taking the date and...

My only thought there is that your bat/ps1 file is not 100% identical to your command. To me it sounds like the bat file or ps1 file is not running...

I'm not sure what you mean by "moving onto the next table" but looking at your script, I suspect that your script is running and never ending, right? Your while...

I can only think of 2 reasons for this. First is permissions - are you using the same account to run the bat/ps1 file or are you changing accounts and...

Might just be me, but is sounds like you are trying to reinvent the wheel. What you are asking for sounds a LOT like a document control tool to me....

Just wanted to add that this isn't a "microsoft defect" as it is the job of the DBA to make sure things are properly sized. I wouldn't blame DELL if...

I think the only way to do this entirely in SQL Server would be with "REPLACE" statements (ie replace <br> with a newline character) and after replacing everything you want...

My first step would be to reach out to your IT dept to see what URL they are trying that is saying that HSTS isn't enabled and verify that the...

Quick google of the answer brought me to this blog post by Pinal Dave (super smart guy!):

https://blog.sqlauthority.com/2017/02/13/sql-server-fix-error-19456-none-ip-addresses-configured-availability-group-listener-can-hosted-server/

That tells you how to fix it, but to quote what he...

To add to what Grant said, I would also like to know why you think that is a "common database maintenance task"? My opinion, database maintenance tasks include things that...

I've not set something like that up before, but I'd try taking different things out of the equation. Can you query it without using powerBI? or is it slow if...