Forum Replies Created

Viewing 15 posts - 2,071 through 2,085 (of 9,720 total)

  • RE: Are the posted questions getting worse?

    TomThomson (1/25/2016)


    GilaMonster (1/25/2016)


    Bandwidth, latency and data out of the country (for 1 and 3)

    I see the same. Plus in the EU it's probably illegal to host the data outside...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Temp Table column suddenly becomes NOT NULL ???

    Okay. This is driving me batty.

    New code (with datatypes fixed) works fine ....

    ------------------------------Data file size----------------------------

    IF (SELECT OBJECT_ID('tempdb..#dbsize')) IS NOT NULL

    DROP TABLE #dbsize;

    CREATE TABLE #dbsize

    (Dbname...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Temp Table column suddenly becomes NOT NULL ???

    Luis Cazares (1/22/2016)


    Brandie Tarvin (1/22/2016)


    Luis Cazares (1/22/2016)


    You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

    You're effectively not inserting any null values explicitly, but you were...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Temp Table column suddenly becomes NOT NULL ???

    Luis Cazares (1/22/2016)


    You're using sysname as datatype for your columns. Sysname is by default NOT NULL.

    You're effectively not inserting any null values explicitly, but you were missing the column in...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Temp Table column suddenly becomes NOT NULL ???

    I understand what you're saying about the SYSNAME, and I agree I need to fix the code.

    But if that's the case, why did fixing only the driveletter column, which is...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Temp Table column suddenly becomes NOT NULL ???

    Eirikur Eiriksson (1/22/2016)


    Quick suggestion, change the #dbsize create script

    😎

    CREATE TABLE #dbsize

    (

    Dbname SYSNAME ...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Ran into something weird with temp tables this morning / yesterday. I have resolved the problem, but without understanding what the problem really was. Would appreciate some insight if anyone...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Two years from now he or his successor are going to be very irritated about their design.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (1/20/2016)


    Alvin Ramard (1/20/2016)


    Ed Wagner (1/20/2016)


    Steve Jones - SSC Editor (1/20/2016)


    This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Jacob Wilkins (1/19/2016)


    Eirikur Eiriksson (1/19/2016)


    GilaMonster (1/19/2016)


    *sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    jasona.work (1/19/2016)


    Paintball is getting more and more complicated...

    I wonder if it'll work with Express or if it needs Enterprise?

    That is flippin' brilliant.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    SQLRNNR (1/19/2016)


    BL0B_EATER (1/19/2016)


    SQLRNNR (1/19/2016)


    GilaMonster (1/19/2016)


    Talking about dressing up a CV, the last time I used an agency (well over 10 years ago), they sent me to an interview. At the...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    Hugo Kornelis (1/19/2016)


    BL0B_EATER (1/19/2016)


    Oh sorry forgot to mention they also asked me who Paul Randal is / what a MVP is? ( Only because I put down my mentoring /...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    And the joyous news of the day is no moving the corporate monitoring dbs over to our new servers because we own the servers so are expected to do our...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • RE: Are the posted questions getting worse?

    BrainDonor (1/18/2016)


    As the Testing forum doesn't appear to be the busiest area of this site - if anybody here has played with SQL Test I'd appreciate them taking a quick...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 15 posts - 2,071 through 2,085 (of 9,720 total)