Forum Replies Created

Viewing 15 posts - 226 through 240 (of 4,080 total)

  • RE: Are the posted questions getting worse?

    Jeff, if you're in Troy looks like you're just over an hour away from the BLT in Birch Run. They might deliver for the right price. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Datetime Field

    If you don't care about hours, minutes and seconds, your column should have a datatype of DATE, rather than DATETIME.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Adding Leading Zeros to Integer datatype

    Thanks Jason. I never format data in SQL itself, so I had no idea about the performance hit. But I just tested it for...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Adding Leading Zeros to Integer datatype

    Little known, little used, and you should not use this until you are displaying data or outputting it to a client program.

    declare @int int =...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Sean Lange (9/9/2016)


    The Dixie Flatline (9/9/2016)


    I can have a heavy SQL test running and still play a game at full graphics settings

    So can I !! ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I would still be chewing as they applied the paddles and yelled "CLEAR!"

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I can have a heavy SQL test running and still play a game at full graphics settings

    So can I !!

    Of course, I'm still playing...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I have been making bacon like that for years...never knew it had a name. Another great way is to put a liberal amount of brown sugar on top...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: The Bones of SQL - The Calendar Table

    I think the link was premature. The article on the Holidays table should be out next week. Sorry I didn't include both in one article, but...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Still weird that he was so confident the scalar UDF performed at least as well as NULLIF; there's no way he ever tested it, so whence the confidence?

    Confidence can come...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Okay.... although I'm not going back into the divide by zero thread.

    Both SET ANSI_WARNINGS OFF and SET ARITHABORT OFF will give him the behavior he wants....

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Lacquered bacon, also known as candied bacon, is (American) bacon slices smothered in brown sugar and a bit of red pepper flake, then baked.

    http://altonbrown.com/roasted-bacon-recipe/%5B/url%5D

    I can eat it like candy. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I'm not listening anymore.... lalalalalalaaaaaaaaaaaa

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: The Bones of SQL - The Calendar Table

    Thanks again, all.

    On the subject of varying holidays in multiple locales, I haven't pushed the concept beyond what I mentioned with having a separate column. ...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Is Division by Zero NULL?

    Totally unsurprising, Gail. Except perhaps to Mr. Hart.

    He's obviously a newcomer to SQL Server if he is trying to make a case for scalar functions. What he...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 226 through 240 (of 4,080 total)