Forum Replies Created

Viewing 15 posts - 1,546 through 1,560 (of 9,643 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (7/3/2012)


    For anyone not on/not paying attention to twitter.....

    It seems to be official.... I'm a Microsoft Certified Master for SQL Server 2008.

    https://twitter.com/SQLintheWild/statuses/220252281847808001

    Congrats. I'm not surprised that you made it.

  • RE: NULLIF 1

    WayneS (7/1/2012)


    Ron - thanks for the question.

    All others: Ron (aka bitbucket) has contributed ~ 75 QotD questions, and this is the first one that I've seen from him with this...

  • RE: Temp Tables

    Toreador (6/26/2012)


    ScottPletcher (6/25/2012)


    2. A Table Variable can have primary keys and indexes defined

    Baloney.

    "Defined" is inherently an action, not a state.

    You cannot "define an index" on a table variable in SQL...

  • RE: NULLIF 1

    Having a different number of columns in the query vs. the answers is wrong. In no case would the query supplied have a 2nd column return NULL. I...

  • RE: Are the posted questions getting worse?

    Having one of "those" days today, which really started last Wednesday, so I guess we're almost up to one of "those" weeks.

  • RE: Temp Tables

    I chose the wrong answer (true, false) for all the reasons listed by others. I chose it knowing that there was a good possibility I'd be wrong because of...

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (6/20/2012)


    The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

    But I may not find...

  • RE: XML

    Personally I'd probably use script component and handle it in .NET. .NET handles XML pretty well.

  • RE: Index defaults 1

    Hugo Kornelis (6/14/2012)


    There are also a few people who didn't consider the possibility of unique constraints being defined in the same CREATE TABLE statement, for instance because they have the...

  • RE: Clustered Index Seek Causing Poor Performance - Suggestions For Indexes

    ASITKAUSHIK (6/14/2012)


    You seems to be using a lot of functions on the fields in the select. Most of it is converting DateTime field to 112 format. IS that be avoided....

  • RE: Index defaults 1

    Okay, I got it wrong. I personally create constraints (other than PK and DEFAULT) separately from the CREATE TABLE statement, so when it says " execute a batch that...

  • RE: Managing Risk

    For some reason I always seem to be the "dissenting voice". I'd like to think it's not because I'm a know-it-all, but because all to often decisions are...

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/4/2012)


    Gianluca Sartori (6/4/2012)


    mtillman-921105 (6/1/2012)


    So I suppose a lot of people rent in Europe?

    70% of Italians own the house they live in.

    Well, sort of.

    Who owns the house while you're...

  • RE: Are the posted questions getting worse?

    Wish I had the income to afford a $1.5 million house.

    Wish I lived in Memphis where you can get a house for $100K.

    The house we just bought was a short-sale...

  • RE: Career Engagement

    I'm not sure where I fall. I'm not doing exactly what I want, but my job isn't bad. It's hard to beat a full-time telecommute position that pays...

Viewing 15 posts - 1,546 through 1,560 (of 9,643 total)