Thanks. Picture speaks a thousand words. So

--Example table

create table Labels

(Id int identity (1,1),

Value varchar(20),

IntSequence bigint,

ExternalSequence bigint,

BatchId int)

-- Insert some data

Insert into labels

(Value, IntSequence, ExternalSequence, BatchId)

Values

--batch 1

('exampleValue', 1,1,1),

('exampleValue', 2,2,1),

('exampleValue', 3,3,1),

--batch...

Success! The problem was in the raw data!! I was using a bulk insert to populate the raw data table, which came from a text file. There was an...

Thanks Gail, that's very useful example. My only reason for doing a loop is that there is extra work being done before the insert which I've excluded for clarity....

That is true,...

Here is the code. What is weird is, I can get this to work as expected on my test system and if I write out the IF NOT EXIST part...

We've switched back on the offending application and can't see any issues at the minute with the log increasing.

However, I've been running a SQL trace and can see...

Beatrix Kiddo (6/17/2014)

They're inextricably linked.

However, I came into the office today and found...

Thanks. For the post above, this isn't a problem with temdb data, but the tempdb log.

Quick update. Yesterday, I monitored the log usage all day and found it...

Thanks for the reply.

I've been doing some reading since this morning to try and understand what is happening.

Initially the log was set up as being 1GB in size with autogrowth...

Thanks for the replies.

I checked the query plans and they were both the same.

However, I've managed to find why the times were different! The query looks at a...

Thanks. That doesn't work unfortunately and still performs just as badly.

Just talking this problem over on this forum, I think I have solved it by using a temporary table...

Is there actually free space in the data file? If you run the following command on the database in question, what is the result?

Select (select

...

Many thanks for the reply. I am on build 11.0.3128. I've only applied the fix to the ms installer running bug as I experienced this a while back. I...

Thanks for the reply. Only one database (bar master and msdb) are using snapshot isolation. The vesioning would be kept in the version store of TempDB though, wouldn't they,...

The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.