Forum Replies Created

Viewing 15 posts - 31 through 45 (of 71 total)

  • RE: Index ordering?

    quote]GilaMonster (1/17/2011)

    pdanes2 (1/17/2011)

    Seems a little odd to me, the reverse ordering I would have thought should at least cut down on the index reads.

    No, because it's going to scan the...

    January 17, 2011 at 12:44 pm

    #1274364

  • RE: Index ordering?

    GilaMonster (1/17/2011)

    A: No

    B: Maybe, test and see. Doubt it will be a major difference.

    You were right. I tried both and almost no difference. Seems a little odd to me, the...

    January 17, 2011 at 9:07 am

    #1274281

  • RE: Unable to delete or edit

    Grant Fritchey (1/17/2011)

    I also tried the READ COMMITTED SNAPSHOT you suggested, but had to leave the building before the change finished. I'll look at it tomorrow to see if it...

    January 17, 2011 at 7:51 am

    #1274248

  • RE: Unable to delete or edit

    GilaMonster (1/17/2011)

    Generally if you have locks hanging around so long that the timeout (default 30 sec) is hit, you have either badly written code or poor indexing.

    If a query encounters...

    January 17, 2011 at 7:19 am

    #1274237

  • RE: Unable to delete or edit

    Okay, thanks, I'll look into that. One of the problems I'm running into is that Access locks up while waiting for a query to execute. If I hit one of...

    January 14, 2011 at 4:29 pm

    #1273847

  • RE: Unable to delete or edit

    Grant Fritchey (1/14/2011)

    You're in the right place. When you hit a snag, post a question. Tons of great people here ready to help out.

    Thank you. I did have one more,...

    January 14, 2011 at 11:33 am

    #1273708

  • RE: Unable to delete or edit

    Grant Fritchey (1/14/2011)

    I would be very, very, very careful about using NOLOCK. It seems like it solves problems, but it can introduce bad data.

    Hmm, yes, I see what you mean....

    January 14, 2011 at 10:28 am

    #1273678

  • RE: Unable to delete or edit

    Grant Fritchey (1/14/2011)

    It sounds like it could be contention, probably blocking, from uncommitted transactions.

    I think you're right. I never have problems when I work on the DB myself, but I'm...

    January 14, 2011 at 9:06 am

    #1273618

  • RE: Permissions on sysprocesses view

    Nawar.Tabaa (1/3/2011)

    What is the version you are using?

    MsAccess 2007 runs the application, client machines have XP, Vista and 7.

    Windows Server 2008 is the server OS.

    SQL Server 2008 Express R2 is...

    January 3, 2011 at 6:51 am

    #1268459

  • RE: Permissions on sysprocesses view

    Nawar.Tabaa (1/2/2011)

    The user granted "VIEW SERVER STATE", must always be able to query sysprocesses for ALL users.

    Please double check that it's already granted it, and you are not mixing between...

    January 3, 2011 at 4:27 am

    #1268402

  • RE: Permissions on sysprocesses view

    Nawar.Tabaa (1/2/2011)

    Just make sure that the SSMS's connected session is by the user granted the "VIEW SERVER STATE".

    Sorry, I don't understand that. Does that mean I should log in as...

    January 2, 2011 at 1:43 pm

    #1268326

  • RE: Permissions on sysprocesses view

    Update - it quits working when I log out of SSMSE and restart the user app. When I log into SSMSE as sa, it starts working again - I don't...

    January 1, 2011 at 10:28 am

    #1268237

  • RE: Permissions on sysprocesses view

    Nawar.Tabaa (1/1/2011)

    I beleive you need to explicitly grant View Server State permissions to each of the users.

    "GRANT VIEW SERVER STATE TO user"

    I'll be damned - that did it. I...

    January 1, 2011 at 6:39 am

    #1268227

  • RE: How smart is SELECT TOP 1?

    GilaMonster (12/31/2010)

    Typically to see if there are any rows you would use EXISTS.

    IF EXISTS (SELECT 1 FROM <SomeTable>)

    BEGIN

    -- Some processing

    END

    Yes, that...

    December 31, 2010 at 10:23 am

    #1268155

  • RE: Series of INSERT INTO queries, only the first one works

    tfifield (12/30/2010)

    I'm really at a loss here. I set up some test conditions and they seemed to work just fine.

    This was, however, using Access 2007 and ADO against a...

    December 31, 2010 at 9:11 am

    #1268136

Viewing 15 posts - 31 through 45 (of 71 total)