I don't think you can come...

SELECT p.ID PRODUCT_ID, 
       p.PRODUCT_NAME, 
       o.ID ORD_ID, 
      ...

It could be that you are not limiting the maximum amount of memory available to SQL Server?

If you right-click on the server in the SSMS object explorer, then on the...

I can't see how you know exactly where to split the number, for example, how would you know if tbl2 number 1234050360 is 1234-050360 or 123405-0360?

If you are sure you...

Do you have an index on CQRReportInstance(ReportInstanceId) ?

If you use INSENSITIVE when you create the cursor it will make a copy of the data used by the cursor in tempdb...

This *was* good advice back in 2005, but now on SQL Server 2012 and above, table variables can be indexed, are dynamically indexed by default and fully accessible by...

Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different.  However (and you know...

First, if you add a few new-lines the query becomes readable:

SELECT t.PartNumber, 
       t.CompanyName, 
      ...

Of course, that recommendation also comes with the warning that if the hashbytes are different, then the rows are guaranteed to be different.  However (and you know this but...

SELECT CONCAT('
SELECT ''', QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),  ''' [TABLE_NAME], COUNT(*) COUNT 
  FROM (SELECT ',x.c, '
          FROM...

That's just the list of columns from the cross apply "x(C)", you can...

So it's for staging tables on your database, not your application tables?

SELECT CONCAT('
SELECT ',x.c, '
  FROM ',QUOTENAME(t.TABLE_SCHEMA), '.', QUOTENAME(t.TABLE_NAME),'
 GROUP BY ', x.c, '
HAVING COUNT(*) > 1;')
  FROM INFORMATION_SCHEMA.TABLES t
 CROSS APPLY (VALUES(STUFF((SELECT ',' + QUOTENAME(c.COLUMN_NAME)
...

Hi, I have a TVF that pulls column details from sys.tables so that it can produce some dynamic sql to generate a hashbyte.

This needs to be dynamic as it...

Wouldn't it be a hoot if the optimizer fooled everyone?  That IS the nature of CTEs.  No one will actually...