Forum Replies Created

Viewing 15 posts - 2,776 through 2,790 (of 7,484 total)

  • RE: ACID Properties Question

    Hugo Kornelis (1/25/2014)


    I'm not sure if I would call it bad things. Neither would I call the option of non-durable tables in Hekaton a bad thing. As long as a...

  • RE: ACID Properties Question

    Hugo Kornelis (1/24/2014)


    Tempdb is specifically designed to ensure that information will NOT survive a system crash.

    Yes, it is - and that means that the ability of a temporary table to...

  • RE: Are the posted questions getting worse?

    Evil Kraig F (1/24/2014)


    Lynn Pettis (1/24/2014)


    Thanks to all who answered my question so far. I was just curious as I overheard one of our SAs make the comment that...

  • RE: Replication

    Hugo Kornelis (1/24/2014)


    L' Eomot Inversé (1/24/2014)


    Yes, but how is release of the log records prevented?

    My guess is that the information on that page you used is incorrect. But I have...

  • RE: Today's Random Word!

    Ed Wagner (1/23/2014)


    BWFC (1/23/2014)


    JAZZ Master (1/22/2014)


    Revenant (1/22/2014)


    Ed Wagner (1/22/2014)


    SQLRNNR (1/22/2014)


    sim

    City

    bestseller

    novel

    New

    Clean

    Sterile

  • RE: Replication

    Hugo Kornelis (1/23/2014)


    L' Eomot Inversé (1/23/2014)


    Interesting question. I thought it worked for all models, but ir's so long since I last looked at replication that I thought I might...

  • RE: ACID Properties Question

    IgorMi (1/22/2014)


    bandarimohan 57273 (1/21/2014)


    ACID property can be allowed for TempDB ?

    I don't know where is that property, but D-Durability cannot be guarantied for tempdb.

    Regards,

    IgorMi

    I don't see why not -...

  • RE: IDENTITY RESEED

    Nice straightforward and easy question. Very good detailed explanation.

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    Interesting question - but the title does seem to contain the answer.

    To run that on my system I would have to switch security to allow SQL users as well as...

  • RE: Replication

    Interesting question. I thought it worked for all models, but ir's so long since I last looked at replication that I thought I might be wrong, so checked in...

  • RE: HASHBYTES

    Nice question, but the real point is somewhat buried in rather a lot of coding clutter.

    Of course the answer relies on there being no hash collision between one of the...

  • RE: Today's Random Word!

    BWFC (1/20/2014)


    Ed Wagner (1/17/2014)


    OCTom (1/17/2014)


    SQLRNNR (1/17/2014)


    Rockford

    files

    Paths

    Roads

    Railroads

  • RE: Tempdb

    Good question, but I thought it was rather easy - provided one looks for the three things which one certainly can't do to tempdb and avoids worrying about whether one...

  • RE: Database Collation Is Null

    raulggonzalez (1/20/2014)


    Sure, but considering the results differ from 2008R2 Standard to Enterprise, if that was the latest version, it'd be still a problem... I've no 2012 Enterprise handy to test...

  • RE: SQL Server Browser

    Koen Verbeeck (1/16/2014)


    Nice question, but a bit ambiguous.

    I can start SQL Server Browser with the command net start sqlbrowser.

    No switches there 😉

    I didn't know it could be started from...

Viewing 15 posts - 2,776 through 2,790 (of 7,484 total)