You could add an IsCurrent bit column and set it to 1 for the most recent row and update older rows to 0. So no need for copying old data...

To select all rows from CustomerLeft change join precedence by parentheses:

SELECT *
 FROM dbo.CustomerLeft AS cl
 LEFT JOIN (dbo.CustomerContact AS cc 
 INNER JOIN dbo.EmailDomain...

LOL this has to be an add bot.  Informatica hasn't had a major update in something like over a decade and doesn't support(or barely)...

Modifying a partition function in SQL Server is not quite as simple as altering a partition statement with the changed dates. Once a partition function is created and associated with...

DROP TABLE IF EXISTS #T
GO
CREATE TABLE #T (Col1 VARCHAR(100));

INSERT INTO #T(Col1)
VALUES ('UIMth: 07/01/23 UISeq: 444 Header Reviewer: DN'),
       ('UIMth: 07/01/23 UISeq:...

You can change the collation of a column with an alter statement:

ALTER TABLE MyTable
ALTER COLUMN MyColumn VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CS_AS

You could add a computed column to your table...

You can create a column on a database that is not case sensitive to be case sensitive

CREATE TABLE MyTable
(
    MyColumn VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CS_AS
)