Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 9,706 total)

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/25/2013)


    Brandie Tarvin (1/25/2013)


    L' Eomot Inversé (1/25/2013)


    ... but the rest of you (with some shining exceptions) are almost as good at lowering the level as I am.

    Ah-HEM. I...

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (1/25/2013)


    ... but the rest of you (with some shining exceptions) are almost as good at lowering the level as I am.

    Ah-HEM. I am BETTER at lowering the...

  • RE: Orphaned Transaction Log File Issue

    Perry Whittle (1/24/2013)


    I would use the sys.database_files catalog and compare that against sys.master_files

    That doesn't show me anything different from what I expect to see. I just see the data file,...

  • RE: Orphaned Transaction Log File Issue

    DOH. I just realized the bad file thinks it's a secondary data file. Maybe the instructions I found will work.

  • RE: Are the posted questions getting worse?

    I would love the advice of anyone who has dealt with orphaned transaction files before. My post is here.

  • RE: Are the posted questions getting worse?

    Surely there is a setting in BIDS to turn off data caching, like in Crystal Reports. Isn't there?

  • RE: Fun with ACID

    asok14215 (1/17/2013)


    Sorry for being pedantic, but I think "D" always stands for "Durability"...which you do use, but you also use "Duration", which I've never heard used for "D".

    Apparently my brain...

  • RE: Are the posted questions getting worse?

    Lowell (1/18/2013)


    Brandie Tarvin (1/18/2013)


    All we need is an actual Go Faster flag for the database, and everything will be FINE.

    got your fix right here:

    MINE.

    I wonder how much the devs...

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/18/2013)


    wolfkillj (1/18/2013)


    Evil Kraig F (1/17/2013)


    Was ill for a week, miss anything of import?

    MS announced that SQL Server 2012R2 will be released in late 2014 and will officially...

  • RE: Are the posted questions getting worse?

    Chad Crawford (1/18/2013)


    wolfkillj (1/18/2013)


    Evil Kraig F (1/17/2013)


    Was ill for a week, miss anything of import?

    MS announced that SQL Server 2012R2 will be released in late 2014 and will officially...

  • RE: Are the posted questions getting worse?

    Revenant (1/18/2013)


    jasona.work (1/18/2013)


    . . . Canada isn't exactly a hotbed of terrorism. . . .

    There is that entrenched extortion organization called Revenue Canada.

    And what about Quebec? Isn't everyone who lives...

  • RE: Are the posted questions getting worse?

    Evil Kraig F (1/17/2013)


    Was ill for a week, miss anything of import?

    The world came to an end, but the Doctor showed up and saved us all.

    Didn't you see the newscast?

  • RE: Fun with ACID

    chuck.hamilton (1/17/2013)


    One of my pet peeves with SQL Server is that it allows the silent violation of of the (d)urability principle.

    Consider SQL replication.

    An INSERT gets committed on the publisher. A...

  • RE: Fun with ACID

    Steve Thompson-454462 (1/17/2013)


    In discussing Isolation, I thought the analogy of the pizza box was clever and appropriate. However then you go on to say:

    if I'm updating customer information in my...

  • RE: Fun with ACID

    paul.knibbs (1/17/2013)


    Bit uncertain about the description of Isolation. Surely the whole point of record locking is that it DOES prevent the other transaction until the first one is finished? In...

Viewing 15 posts - 3,706 through 3,720 (of 9,706 total)