Not sure of your baseline for the data, I'm not sure if just under a minute is good, or bad, for this. However, to case statements:

In the select clause,...

EDIT: (LOL, beaten to it twice. 😉 Ah well, have your choice of formatting then. 🙂 ) /EDIT

Best to do the aggregation as a subquery and your calculations...

A couple of questions:

Have you done any attempts to determine the throttle point, if it's reads from the Daily Transaction DBs, if it's network throughput, if it's the writes local,...

Any chance you can post the table/index definitions and a query your reports use? Helps us to try to figure out if you've optimized to indexes and the like...

I would doubt it. I'd look more for a funky piece of data. If you can, find out what the numeric settings they have are, then go to...

npeters 86796 (9/13/2010)

---

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER TRIGGER [dbo].[zDT_RM00301U] ON [dbo].[RM00301] AFTER UPDATE

AS

set nocount on

BEGIN

UPDATE dbo.RM00301

SET DEX_ROW_TS = GETUTCDATE()...

Considering many of my scripts run 2k characters or more, I'd have thought I'd have ran into it if it did. I just took a breeze through tools-options and...

subash: Can you please do a quick double check if you have triggers on the table? Something hiding underneath could be part of the problem.

If you change that table...

2 things.

If you could set that table data up (the source) as a temp table insert that'd be great.

Your results look the exact same visually as the source, not sure...

The 1 is a literal value of 1. It's an optimization technique to not actually pull anything from the recordset to anywhere, since all you're doing is checking for...

For an easy answer, wrap the entire item with:

IF EXISTS (SELECT 1 from inserted where idcontrato='2' and eicanalid = '91')

BEGIN

--The rest of your trigger code goes here

END

A few significant issues...

THolley, what Steve posted above is your best solution if you're proc based, but if this is straight dynamic SQL from a front end code bed you're basically SOL without...

Well, the sql command you'd want to use would be sp_executesql @sql, with @sql being whatever was typed into text1, and the send command to the...

Using right joins your last table is the one that has to have records, then the second to last to expand it, and so on.

If you're looking for results, no...

You're looking for the REVERSE() function, paired with a CHARINDEX() to find the location of the space.

This can be processor intensive, hopefully this isn't a regularly running proc and is...