Hello Grant,

Sorry I was not clear enough...

Here the sequence of things that happend:

1- The performances are pretty good : "CPU %Processor time" on the prod DB server is around 15%-20%

2-...

I want to add that :

- Auto create statistics

- Auto update statistics

Are both at "ON" in the concerned database.

Regards.

Carl

Thank's a lot Lowell.

I was assuming that these virtual tables were'nt populated in the cas of an INSTEAD Of Trigger.

Regards.

Carl

Effectively, since the leafs of the clustered index contains the actual rows of the table, you don't need a bookmark lookup.

Thank's for your help.

Carl

Thank's Christopher,

here is the ACTUAL execution plan (.sqlplan zipped).

Best regards.

Carl

Here is a clip of the execution plan.

Best regards.

Carl

I don't know how to attach a file in a post.

But the execution plan is a simple clustered index seek.

Regards.

Carl

Sure,

here is the execution plan text:

Clustered Index Seek(OBJECT: ([test_carl].[dbo].[empscumul].[idxa]), SEEK: ([test_carl].[dbo].[empscumul].[stat_no]=CONVERT_IMPLICIT(int,[@1],0) AND [test_carl].[dbo].[empscumul].[employee_id]=[@2] AND [test_carl].[dbo].[empscumul].[start_date]=CONVERT_IMPLICIT(datetime,[@3],0)) ORDERED FORWARD)

Best regards.

Carl

Hello Luke,

The execution plan is : Clustered Index Seek.

Best regards.

Carl

Thank's Luke,

With an index (in this case a clustered index) I would not expect a linear progression.

Regards.

Carl

Hi Matija,

Ok thank's. I noticed that you were changing the isolation level during (inside a transaction). That's why this exception arise.

I made some tests changing the isolation level wihtout being...

Oupps.. instead of this:

Is it true that being in the READ_COMMITED_SNAPSHOT isolation level and switching to the SNAPSHOT isolation level (with : SET TRANSACTION ISOLATION LEVEL READ COMMITED) will raise...

Hi Matija,

I don't suggest to set these database settings at connection time. I wrote : "I ask this question because our ALTER DATABASE statements are not dynamic, they are...

It is with your help that we found.

So thank's to you also. 🙂

Carl

Hello Mohit,

We finally found. It is the registry value:

HKLM -> System -> CurrentControlSet -> Control -> NLS -> Codepage -> 850.

Changing it's value from c_850.nls to c_1252.nls enable us to...