Forum Replies Created

Viewing 15 posts - 16 through 30 (of 106 total)

  • RE: SSIS Derived Columns

    Stewart "Arturius" Campbell (10/22/2015)


    Nice, easy question to end the week on, thanks, Steve.

    However, the answers appear syntactically incomplete, e.g.

    The converts to NULL and ...

    should this not have rather read...

  • RE: Positive or Negative

    I use the positive (which is problematic because a previous developer used the negative).

    I prefer 'Enabled' to 'Active', but since 'Enabled' is a keyword and I consider using keywords as...

  • RE: Identity Column

    Oww, my eyes.

    But other than the formatting, it was a simple, red herring question.

  • RE: Renaming

    We just ran up against this. IT set up a new developer's box, and used the default for the SQL named instance. Which was wrong and would not...

  • RE: Adjusting Model

    Never touched the model before, myself. But after reading that blog, I am seriously considering adding a tally table to it whenever possible.

  • RE: Column aliases

    RLilj33 (9/2/2015)


    david.gugg (9/2/2015)


    Xavon (9/2/2015)


    Sean Lange (9/2/2015)


    I am guessing that Aaron did NOT convince Steve to use = instead of as. 😉

    I have to say that I disagree with Aaron on...

  • RE: Column aliases

    Sean Lange (9/2/2015)


    I am guessing that Aaron did NOT convince Steve to use = instead of as. 😉

    I have to say that I disagree with Aaron on this. I find...

  • RE: Column aliases

    I answered based on remembering that blog, but personally think the complete list is 13

    (=, AS, or ' ') * (no delimiter, ', ", or []) + 1 for...

  • RE: Redirecting Output

    rmechaber (8/28/2015)


    Easy question, though I did have to think about it, as other combinations not provided as QotD options would have worked: 1, 3, 2 for example. Strip out...

  • RE: How many environments?

    In theory my company has five environments:

    Dev - where we all work, anything goes, drop and recreate at the drop of a hat.

    QA - once dev is 'done', it gets...

  • RE: Making Guesses

    jckfla (8/11/2015)


    Xavon (8/11/2015)


    IT needs a more general version of Hofstadter's law. That is why when asked to estimate time, I generally add a 150% pad (100% for issues during...

  • RE: Making Guesses

    IT needs a more general version of Hofstadter's law. That is why when asked to estimate time, I generally add a 150% pad (100% for issues during dev, 50%...

  • RE: Max DB Size for SQL Server Express

    Hooray, more trick questions. Don't worry about the question itself, the title is the only important part. 🙁

  • RE: SQL Server 2014 Clustered Maximums

    I think it says something about me, that the first thing I thought was 'Why would you have Super Mario Bros. on your cluster?'...

  • RE: Would You Pay To Wear Jeans?

    Where I am now, we are required to wear business casual shirts and long pants; but those long pants can be jeans. Dress shoes are generally required. We...

Viewing 15 posts - 16 through 30 (of 106 total)