I'm assuming that your tables are NOT named T01. T02, T03, etc and so I'm asking the following question again...

Is there a pattern to the actual name of the...

Still there is a shorter version:

select * 
from leftTable  T1
join rightTable T2 
   on (
      T1.C1...

Hi,

I'm have sysadmin rights but it is not possible for me to delete auto created statisitcs. I receive the message, that the statistic doesn't exits or I do not...

Just in case you're not been able to find the reference for the formats...

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql?view=sql-server-ver15

Heh... to Sergiy's point, I wonder how many supposed "Big Data" problems are actually BIG "poor design", "poor implementation", "poor requirements", and "poor coding" problems.  To wit, my definition of...

Thanks Jeff and Sergiy for all your help.

I have a much better understanding now and have some design ideas: instead of triggers, partitioned views I can use not just...

It would probably help your cause a bit if you posted what several good and bad rows actually look like.

Still there is a shorter version:

select * 
from leftTable  T1
join rightTable T2 
   on (
      T1.C1 = T2.C1...

It's too bad that...

Is there a pattern to the actual name of the tables and are all of the tables in the same database?

Thanks, Erland......

p.s.  I you do decide to move the table (whether you turn it into a partitioned view or not), you should keep the original table for a couple of weeks...

I don't see much advantage to changing ProcessName or Type to a key from a "process table" or "type" table.  In the face of the other tables, it's...

Since you're using a version of SQL Server that's 2012 or above, here's a method that eliminates the need for a self join and the extra reads that go with...

Terry,

If this is truly a log table (the name of it implies that it is) , there are two things that I'd do.  As you say, changing the NVARCHARs to...