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.

Yes,...

There is an article on the same problem here: https://www.mssqltips.com/sqlservertip/5279/sql-server-error-query-processor-ran-out-of-internal-resources-and-could-not-produce-a-query-plan/

What State did the error return? (1 or 2)

State 1 - The query timed out due to the...

drop table if exists #t1
drop table if exists #t2
drop table if exists #t3

go
set statistics io, time on
go
SELECT p.FIRST_NAME,
       p.LAST_NAME,
  ...

I've got a (8 years old) Dell XPS 8700 desktop with a  i7-4790 and 28GB RAM, and a SanDisk Ultra II 960GB SSD with the tempdb on...