Andreas,

Thank you for your reply.

I would think there is space to be reclaimed:

which makes sence, as the database is logshipped and there are no big transactions running.

The...

Hi all,

Just a quick not to maybe help the next chump wrestling with this. 🙂

The problem appears to be in both the date (thx Ken) and the bit datatypes.

Unfortunately, both...

Gerald and Ken,

First of all, thanks for your suggestions. 🙂

Gerald,

Changing the ID to an unquoted string made no difference.

Ken,

Changing the datetime string to the format you specified and removing the...

Hey Gerald,

I wish it was that easy.

Part of my problem is that the query is succesful in SSMS, I can only get the error values by debugging a run execution,...

Hi,

I'd hoped to skate by on this, as neither the DDL or the DML change, but here you go.

The data included is the data that causes me my headache.

DML:

INSERT

INTO Requests...

Tom,

Thank you for looking at this for me.

Tom.Thomson (2/2/2011)

---

Judging by your sample data, 20k rows will need a buffer of a bit less than 9 Mbytes; that's something I would...

Gail,

I'm going to attach the create table statement and a data-sample.

This is one of the tables of our interfacing environment.

PD_Id contains the primary key, a combination of the dataset...

Gail,

First of all, thanks for replying.

GilaMonster (2/2/2011)Honestly, in this case I'd suggest drop the hints entirely and consider reworking the application process. It doesn't sound efficient, it doesn't sound like...

Hello everyone,

As I suspected, Eddie's solution was the right one. Thanks. 🙂

If anyone's curious, the statement now takes less than 2 seconds, which is good enough for me.:)

For some reason,...

Eddie,

Thanks. 🙂

I'll try tomorrow, but I think that may be it.

I've allways created indices for the queries that I perform, but never thought about the fact that the database may...

Victor,

Thanks for your reply.

I've scanned the document, and found the statement to extract the number of reads/writes.

And the logical reads are through the roof.:ermm: (Over a million)

Logical writes are at...