I did retest it with order by desc but it looks even more resoure consuming...

any other ideas?

Thanks a lot for the help, mj

Thanks a lot for the help.

It looks though that this query returns double size of the data then the original one.

I'll try to modify it.

Thanks a lot again, mj

I need to detect SQL clients.

On all of the installtions I see there's no Binn directory at all. But in the registry I have Microsoft SQL Native Client and...

Thanks a lot for the ideas, guys.

Any help on what exactly I need to select in the light trace for log on?

Thanks again, mj

Thanks a lot, but I cannot run the Profiler 24/7.

What about for some work around?

This is what I currently do for Oracle - I have an after logon trigger that...

I changed the indexes around but converting the non-clustered to clustered index on most accessed field did not change a thing. I also tried different combinations for the clustering.

What else...

There are no SPs in the applciation - all handled by Rogwave library's calls - prepared SQL. No triggers, or FK - so the app will not lose times on...

Thanks a lot, the password and the Auth are the same for all 3 connections.

But here is the fun part - if I change the JRE version from jRE 150_11...

Im sorry I did not post the info correctly - there is an existing SQl server 2005 client tools installation done not by me and there's no docs on what...

This is a Sql server 2005 client only installation on win 2003 server Sp2 64 b machine. I have only SQLCMD visible - nothing else (like Surface area, Conf...

Thanks a lot for your example.

Could you, please elaborate more on the optimization part - "You can also loosen the SERIALIZABLE and optimize more".

Thanks again, mj

But when I select them, I have to lock them as well, or the other processes running on the same table may modify them. And then I have deadlocks all...

Yes, I have both local and remote connections enabled, and did restart the service after that. I'm using the Express edition that come with Visual Studio.

Nut I get the same...

I have a prolem configuring sqlcmd to work - I can ping the server, I can execute -L option and see all servers, the SQLbrowser is running, looked at all...

Only to the SQL server. Cannot change the query either. The application dev team will send me a hot fix, but I do not know when that will happen...

Thanks a...