Using the OP's original example:

SELECT *
     , file_date = datefromparts(f.string_date % 10000, f.string_date / 1000000, f.string_date / 10000 % 100)
  FROM #t
...

I see a lot of focus here on not reindexing at all - mostly because no one can prove that reindexing improves performance.  I am not sure how that myth...

If GETDATE() in SSMS is returning UTC - then using GETDATE() in an agent job will also return UTC.  If ServiceDate is stored in UTC then your calculation would be...

The ONLY reason I see to use powershell for a backup process would be if you needed to move the file to a location that the SQL agent service...

I find it to be much easier t0 update the file locations directly - take the database offline - move the files and then bring the database online.  Detaching the...

I would not even approach it as a stepped migration - instead, I would evaluate the existing processes and rewrite them in a project deployment model.

In many cases, the original...

Shouldn't that be 'GRANT WITH CALL GRANT' ???

I have to wonder why you have setup a SQL Server agent job - running an SSIS package - as an 'interactive' process in the first place.  That is not...

Need more information - first, I have to assume the FCI is configured with hosts in the same data center since that will be using shared storage.  Failover for the...

I find it interesting that this doesn't work when using the correct zero date for a datetime2:

DATEADD(dd,DATEDIFF(dd,'1900',DateValue),CONVERT(DATETIME2,TimeValue))          --2nd...

Probably the best way to handle that is to use the functionality built into SQL Server agent to manage a multi-server environment.

https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-multiserver-environment?view=sql-server-ver16

Ideally, you would use a server outside the...

It depends on the how the cluster quorum was configured in the first place.  If all nodes in the cluster have a quorum vote - then you have 2 possibilities.

...

Here is a start:

SELECT UIMth = substring(t.yourcolumn, 8, 8)
     , UISeq = substring(t.yourcolumn, 24, charindex(' ', t.yourcolumn, 24) - 24)
   ...

You still seem to think SQL Server should materialize the 'view' before applying the filter from the outer/calling query.  SQL Server does not do that - it compiles the view...

The reason this happens is because the conditions cause a different execution plan to be generated - and that new plan performs those calculations before applying the where clause.  That...