I think my initial confusion was the OP said "log file should automatically truncate" It's not the log file that truncates but the transaction log that truncates which is just...

Yes, I think I read the question it too quickly and subconsciously thought the OP meant shrink. I can see now truncate is an official MS term for it but...

  Might just be a difference in lingo here but they DO automatically "truncate".  They just don't automatically shrink.  Is that what...

Log files don't automatically truncate.

The reason you can't shrink it might be because there is a stuck transaction, maybe someone has some code with a begin transaction but no commit...

You have SUM in the wrong place.

Also, should not be ELSE '0' but ELSE 0 or ELSE NULL

Also, only need to group by CT.LINTCUSTOMERNUM

SELECT CT.LINTCUSTOMERNUM AS CUSTID,
...

I decided to try to push some buttons on this, and sent an email to the relevant European commissioner, saying The latest "upgrade" of the Microsoft  Winows 10 operating...

You'll also need to identify how many foreign keys there are.  We had a table where it took over 5 minutes to...

• This reply was modified 6 years, 4 months ago by Jonathan AC Roberts.

Before deleting I  create a view vwToDeleteSelect that selects 1000 rows at a time -- this is to delete in batches delete vw from vwToDeleteSelect vw inner join #tempTable1...

• This reply was modified 6 years, 4 months ago by Jonathan AC Roberts. Reason: Updated code to be slightly more efficient

Here is an alternative way to get the results. I think it should perform quite well if you have appropriate indexes on the tables.

Do you have a "Persons" table? If...

Not sure if this is what you want. If you supply the actual code it might be easier to work out what it's doing.

CREATE VIEW xx AS
...

It might be easier for us if you describe what the script is doing.

What is the purpose of that part of the script? Is it to update the temporary table...

Another method which could be used if an intermediate table is required is to create a table valued function, with table variables instead of temporary tables, these behave a lot...

The normal way to do with is by performing an UPDATE followed by an INSERT if no rows were updated, this is sometimes referred to as an upsert:

            
May 8, 2019 at 7:25 pm
            
#3638576

            
            
                                                
        

I've got no idea why the stored procedure would be slower when called from SSIS instead of SSMS. But when I get a SQL statement like that I try to...

SELECT *
  FROM AMilestone
 WHERE AMilestone.SCHOOLYEAR = (SELECT MAX(ASemester.SCHOOLYEAR) FROM ASemester);