It's uploaded and working now

Correct, I updated all statistics with FULL SCAN and I checked that the statistics show they were last updated today. Auto_Create_Statistics is Enabled for the database too.

I've attached the...

I agree, so I tried creating a temp table and clustered index on that inside the stored procedure and inserting all the records from the User Defined Table Type into...

In the slow stored procedure:

Looks like the Query Optimizer thinks (estimates) that the Index Seek will result in 6 rows, however, it results in (actual) 380,349 and then joins to...

I completlely understand, I'll see what I can post, I appreciate your time. If it looks like you need some more details in the text output format let me...

I was thinking that was correct until I did the following test

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

BEGIN TRANSACTION

UPDATE dbo.Table SET Name = 'Test' where ID = 1

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE

EXEC...

I think this question really makes me think. I thought the log backup chain was broken after a full backup based on this I read on MSDN

"If a log...

Thanks, I'll keep that in mind.

I just realized my question was silly... I need to do an update statement in the trigger instead and join on the inserted table rather than an insert.. doh

But...

Intersting I didn't know that. I looked and the SSIS package was using the Fast load option, I switched that to just use table and the trigger fires now,...

This may or may not be relevant here but we did load testing on our MOSS 2007 website and we were able to triple the user count by enabling BLOB...

My issue is that the varbinary data results of these queries don't match up... Sorry, I probably didn't expain the issue very well..

SELECT SUSER_SID('domain\user')

AND

Results from

whoami /user as a...

Is this login for a 3rd party application? I ask because I discovered an interesting issue with MS Dynamics that uses SQL Logins for each user version 8. ...

Ok, I now see my confusion by looking closer. I was confusing WITH NOCHECK and NOCHECK CONSTRAINT while reading the syntax of ALTER TABLE. Now it's clear, there...

That is acutally the command I've already tried to execute manually. It runs OK, but shows 0 records cleaned up. If you look under the SQL Agent job...