This is exactly what I was looking for.

How can I incorporated into a SP that will return also the result set?

Thanks so much for the help,

Tom

Absolutely sure - This is the error returned to the applciation:

[Microsoft][SQL Native Client][SQL Server]Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim....

Thanks a lot for your post. It took me a while as the project was on hold for several months.

What I really need is equivalent of the OUTPUT clause in...

It looks that SQL server 2005 is picky - the problem was in the way the luns were setup - as soon as the permission's were updated in Disk...

Thanks a lot for the replay.

But why SQL 2000 doesn't require that?

Is this 2005 limitation, or depends on the edition - Standard?

Thanks a lot, mj

Have connectivity issues right now.

I'll post the queries as soon as I could connect to the box.

Sorry about that.

mj

Yes, I did but nothing really changed.

I used this command to do it:

UPDATE STATISTICS er_account WITH FULLSCAN, NORECOMPUTE

Thanks,

mj

Thanks a lot, but unfortunately, the server is correctly configured... Both TCPIP on server and client. Also, in the Surface Area, both Remote and Local connection, TCPIP and Named Pipes...

I do not believe that this is an issue of using bind variables or literals.

Please, note that the slow statement is the one that uses bind parameters, not literals. I...

This is what I have tried but I still cannot create unique index on the view because there are repetative values and I cannot use distict.

So still doesn't work for...

All indexes are rebuilded and the stats are updated.

The execution plans show that the optimizer uses FTS on the Name table coming from the NAME_view which makes no sense to...

This is my SQl server version after I have applied SP2 - 9.00.3042.

I saw some higher numbers in the previous replies - like 3061. How to get to this numbers...

Any advice on how exactly to configure the memory on 64 bit?

So far I have 8GB for the OS and did not limit then after reading (or misreading) the...

Thanks a lot.

yes, the application uses transactions.Unfortunately, I cannot use uncommitted transaction. For a while I'll be on SQl server 2000 (2005 is scheduled for late 2008) so I have...

I tried the advice to use clustered indexes, and still do not see any improvement in the inserts. Systematically seeing reads on them as the example above.

Investigated the connection from...