Forum Replies Created

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

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

  • RE: Azure SQL Database

    Koen Verbeeck (1/13/2014)


    Easy question, but the way it is formulated it seems backups are entirely not possible (the MSDN page gives the same expression) and that your data is not...

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