Forum Replies Created

Viewing 15 posts - 331 through 345 (of 667 total)

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (9/30/2010)

    Totally different topic: how big was the biggest SQL statement you had to deal with?

    This is a statement generated by our BI front-end.

    Surprisingly enough, after 4 minutes of...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 30, 2010 at 3:51 am

    #1229506

  • RE: VERY strange behaviour with invalid subquery

    steveb. (9/27/2010)

    I thought the issue is that the column does not exist in the table in the sub-query. Not that the sub-query returns mulitple rows.

    It definetly throws an...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 27, 2010 at 8:32 am

    #1227719

  • RE: VERY strange behaviour with invalid subquery

    @Brian: You say this certainly would throw an error on SQL2000. I just tried this on our last remaining SQL2K box, and it does indeeed. However, the error I am...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 27, 2010 at 8:13 am

    #1227705

  • RE: Are the posted questions getting worse?

    GilaMonster (9/22/2010)

    I bought this one for my manager at the bank before I left (farewell gift). He had it prominently displayed in his office last time I saw. http://www.despair.com/idiocy.html

    LOL. Don't...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 22, 2010 at 6:07 am

    #1225492

  • RE: Talking baseball

    Steve Jones - Editor (9/20/2010)

    Make it fun above all. I agree with Ray, and I think a mix of fundamentals and fun is best. Don't worry about seriousness, or anything...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 22, 2010 at 4:22 am

    #1225438

  • RE: Talking baseball

    Thanks Ray. One thing you forgot to mention was

    - Relax and have fun!

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 20, 2010 at 8:17 am

    #1224046

  • RE: Are the posted questions getting worse?

    Yeah, congrats from me too. Just leave it there for a little while as you suggested. Nice to look at, not just for you but for all others to see...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 20, 2010 at 4:43 am

    #1223911

  • RE: Talking baseball

    Just to take you away from ML, NL and whatever. Our season down here in South Africa is about to kick off in about 4 weeks time. Really looking forward...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 18, 2010 at 4:06 pm

    #1223513

  • RE: SQL Query

    LOL.

    I was just thinking, if the BookID is 2GB as well, then taking an average of 2.5mm for the width of a single character on a barcode, that would amount...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 8, 2010 at 11:51 am

    #1218134

  • RE: SQL Query

    You should give appropriate data types. Having a text field (which allows for 2gb) as a PK just isn't a good idea.

    It is not just a bad idea, SQL 2008...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 8, 2010 at 11:17 am

    #1218117

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/2/2010)

    Alvin Ramard (9/2/2010)

    FYI, we need approximately 25.4 posts per day to hit 20,000 by Nov 18th.

    Who's going to volunteer to make the .4 post?

    Would it be OK if...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 2, 2010 at 8:02 am

    #1215621

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/2/2010)

    FYI, we need approximately 25.4 posts per day to hit 20,000 by Nov 18th.

    That should be easy. Here's my contribution for the day.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 2, 2010 at 7:55 am

    #1215613

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/2/2010)

    LutzM (8/31/2010)

    [quote-0As requested: "Mädchen für alles" = a utility man or a gofer (not in the meaning of an unskilled worker but rather a person that's called whenever something...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 2, 2010 at 7:47 am

    #1215602

  • RE: Are the posted questions getting worse?

    Alvin Ramard (9/1/2010)

    Lynn Pettis (9/1/2010)

    GSquared (9/1/2010)

    Here's an interesting one. This is the list of skills someone wants for their "DBA":

    Must have advanced proficiency and extensive knowledge of web development...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    September 1, 2010 at 3:12 pm

    #1215309

  • RE: Is BCP deprecated in SQL 2008 R2 or not?

    Coming to think of it, wasn't there some DMV that shows what deprecated feautures have been used since the last time SQL started up? Or am I just dreaming?

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    August 31, 2010 at 1:06 pm

    #1214571

Viewing 15 posts - 331 through 345 (of 667 total)