Forum Replies Created

Viewing 15 posts - 16 through 30 (of 122 total)

  • RE: help with query

    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

  • RE: simplifying query

    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

  • RE: help for Client install detection

    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...

  • RE: when a databases was last used

    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

  • RE: when a databases was last used

    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...

  • RE: reads on inserts

    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...

  • RE: reads on inserts

    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...

  • RE: DSN to SQL 2000 from 64b

    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...

  • RE: 64 or 32

    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...

  • RE: 64 or 32

    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...

  • RE: select for delete

    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

  • RE: select for delete

    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...

  • RE: ‘sqlcmd’is not recognized as an internal or external command

    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...

  • RE: ‘sqlcmd’is not recognized as an internal or external command

    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...

  • RE: select count(distinct col) with nulls

    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...

Viewing 15 posts - 16 through 30 (of 122 total)