-- Query 1: Query Cost (relative to batch): 48.89%

SELECT c.defendant_sid,

    count(*) as [count],

    CAST(MIN(c.calendar_time) as char(20)) as [MIN(calendar_time)],

    (   SELECT CAST(MIN(t.calendar_time) as char(20))

        FROM #temp t

       ...

Here it is one more time - my post gets lost from time to time....

The developer simplified the problem by removing the derived table.  I think this is the best...

StmtText                                                                                                                                                                                                                                                                                                                                                                       

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT c.defendant_sid,

    count(*) as [count],

    CAST(MIN(c.calendar_time) as char(20)) as [MIN(calendar_time)],

    (   SELECT CAST(MIN(t.calendar_time) as char(20))

        FROM #temp t

        WHERE t.defendant_sid = c.defendant_sid

        ) as...

I took a look at the execution plans for the example code included above.  They both use parallelism, but the second one (with the problem) is more complicated and has...

I think I'll skip the derived table.  I can never tell what I'm going to get from the developers .  The original query...

See Q295371: PRB: Filegroup Log Restore May Fail with Error Message 4305

Error Messages

SQL Server 2000

Server: Msg 4305, Level 16, State 1, Line 2

The log in this backup set begins at...

It's good to use cached data, but only if it's not stale.  It would be interesting to select from a table with a computed column based on GetDate().  The cached...

Are you sure the connection is failing from QA?  Stress related TCP/IP socket issues, for example, are typically sporadic - Q328476.  Otherwise, perhaps DBCC FREEPROCCACHE might force it to refresh. ...

quote:

---

Look for the line

goPackage.SaveToSQLServer

in the VB file. Check Books Online for the full syntax. Be aware that you'll...

The second to last menu item in the "Package" menu is "Disconnect Edit...". It lets you edit various properties of connections, tasks, and work flow. I sometimes use...

I didn't get a second chance.

I did answer the first question correctly, but not the second. I assumed that the email would have the same question as the question in the link. Guess...

As a test, I would try a RAISERROR('trigger', 16, 1) in the trigger and catch the error after the query directly invoking the trigger. Perhaps your error is not...

If the insert is large, perhaps it can be broken up into several inserts to keep the transaction size reasonable.

Because it works in QA, it must be DTS related. Is the package scheduled to run as a job? Did you check the process? Any blocking? ...