Hi Holger,

I found this (spid5):

Table error: IAM page (1:166529) (object ID 2, index ID 255) is out of the range of this database.

And for sure, this error concerning the CHECKDB:

DBCC...

Found my answers on the internet (thanks google).

To have this error there must be several conditions met:

- Having a table with a cluster index and a column of datatype image...

To be more precise : You can see it on the properties windows for the database (for the files). Or you can query it like this:

select

The problem was just that the SPLIT function cannot handle the space between each of the element passed to it:

This was ok: 'element1,element2,element3,...'

But not this: 'element1, element2, element3, ...'

I just...

Hello John,

Here is preliminary results:

For 898 element for the IN operator:

Using a derived table (SPLIT function):

Network Statistics  

  Number of server roundtrips                       6 

  Number of TDS packets sent                      6 

  Number of TDS...

Thanks Barsuk.

Same kind of issue.

Regards.

Carl

Hello John,

Hope you add a nice weekend.

You are right, I should (and I will test, test and retest) the three scenarios (something I began to put in place last week).

Best...

The SPLIT function used with ADO.NET does not seem to work properly (n.b. I hardcoded the separator instead of passing it to the function):

exec sp_executesql N'SELECT * FROM hasogl.pellpasc.stop s...

Hello John,

at my sense this technique could not scale because every row inserted in the temp table will involve a round-trip to the DB server...

1000 values = 1000 round-trips.

For the...

Hello John,

The values are dynamically chosen by the application user.

We are using ADO.NET.

Could you post an example on how we could build a derived table without using the split function?

Best...

Thans a lot for your post.

I'll try it next week to see how the engine treat it and how it scales...

But I see a limit here:

Having a large INLIST often...

Hello Mike,

thank's, I'll have a look at that as soon as possible.

Should be an improvement in SQL Server itself.

Regards,

Carl

Ok thanks Mike.

A daily human check let an open door for huge problems... If an orphaned connection keep a table lock for an hour and everyone get kept in a busy wait...

Hello Mike,

No not exactly. We don't you extended stored procedure.

I talk about orphaned connections caused by an abnormal end of an application that was connected to the server.

But you can...