IF (
        (
            (ABS(SIGN(@Var1-@VarA))) 
 ...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with the next...

In the old days, particularly with PL/1, we would do the multiple IF's. Because it was easy to slip a new punchcard in the deck when we found we...

> we renamed the sql error log out file in agent properties <<

I think that would require a recycle of SQL Server.  You don't need to do that.  You should...

Try better clustering in a test system somewhere.  You might be pleasantly astounded by the results.

Table dbo.TSys_Lookup_Date D should almost certainly be clustered first on [Date].

Try clustering dbo.T_DeliveryTimetableItem and dbo.T_DeliveryTimetableItemResolvedCost...

Similar to what Grant mentioned, I'd suggest creating a table to help manage the process. Run a process every day to update the table with the next day's planned...

In a single execution, the gain may be small, bring it up to 100K/Sec and that...

• This reply was modified 5 years, 2 months ago by ScottPletcher.

Waiting for locks is normal in SQL Server (or any other relational db).

Whether the waits are excessive is a different q.

Since you've provided no details, to reduce bad effects of...

You could run the job every minute.  But I'd say run the job every 10 minutes (or, I guess, 5 minutes).  Would it really be that big a deal to...

Are you using the standard sp_cycle_agent_errorlog proc or did you try something home grown? ...

In a single execution, the gain may be small, bring it up to 100K/Sec and that difference can...

Just a quick thought: Any IF statement will add an evaluation step to the execution Any AND will do the same Conditionals (IFs) introduce branching, even if there is...

I used a table for the location_id(s) to be combined, so that it would be easy to do multiple combinings.  For example, if you uncomment the (1, 30), you'll see...

In this specific case, I'd recommend you add a couple of triggers to the table to maintain an accurate flag for this in the parent row.

You'd need an INSERT trigger...