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
)

            
July 19, 2023 at 5:52 pm
            
#4239357

            
            
                                                
        

I am with Grant - I don't see any reason to be splitting a table.  No matter what - all development groups will still need access to the original...

Because of the row size limitation in SQL Server, I had to split the columns of a data warehouse table. The combined size of the rows exceeded the permitted limit.

To...

I've had to add an identity column (ID) so the table can be ordered by something:

DECLARE @T table (ID int IDENTITY(1, 1),  A int )

insert 
into...

There is nothing to order the table by. Maybe you should add an identity column to your table first.