Forum Replies Created

Viewing 15 posts - 76 through 90 (of 241 total)

  • RE: Combining union and union all

    Thanks for a good question and a great discussion.

    Once again, the lesson is to pay attention to all the details....

    Rob Schripsema
    Propack, Inc.

  • RE: BETWEEN

    rmechaber (3/5/2012)


    This was a terribly difficult question: I spent 10 minutes looking for the syntax error, catch, gotcha, trip-up, etc., only to submit the straightforward, correct answer.:-D

    Rich

    I did the same....

    Rob Schripsema
    Propack, Inc.

  • RE: EXECUTE

    bitbucket-25253 (2/14/2012)


    Hmmmmmmm Very intesting, so learned more than 1 "trick/work around".

    Again learned more from the discussion following the QOD than from the QOD itself.

    Thanks

    That's often the case, and I...

    Rob Schripsema
    Propack, Inc.

  • RE: Deadlock

    Great question. Wasn't very familiar with this, and I think it will help me solve a nagging problem we've been having....

    Rob Schripsema
    Propack, Inc.

  • RE: SQL Agent Roles

    Good opportunity to learn/review things I haven't needed to use very often (if ever!).

    Rob Schripsema
    Propack, Inc.

  • RE: Querying Geometry Information

    I was fooled by focusing on the 'geometry' type name, rather than on the method name.

    Good question; hats off to Hugo for the excellent follow-up explanation.

    I, too, am not...

    Rob Schripsema
    Propack, Inc.

  • RE: Any reason not to use SQL 2008R2 backup compression?

    At this point we're trying to avoid using third-party tools for the backups. We've looked at all three of those products, and while they have...

    Rob Schripsema
    Propack, Inc.

  • RE: Any reason not to use SQL 2008R2 backup compression?

    Leo.Miller (1/25/2012)


    You do need to check with your system admin that they aren't using anything like NetBackup's De-duplication technology when they make tape backups of the SQL backup files. The...

    Rob Schripsema
    Propack, Inc.

  • RE: Tail Log Backups

    Good question! Got me to review our procedures around emergency restores -- something we've never (yet!) had to do (thankfully!).

    Rob Schripsema
    Propack, Inc.

  • RE: Time Zone

    A timely question. We're starting to have to deal with lots of time related data coming in from multiple time zones and need to come up with a good strategy...

    Rob Schripsema
    Propack, Inc.

  • RE: Christmas Fun

    Uripedes Pants (12/27/2011)


    oh, booo! Rudolph was a scab brought in for an exception - not part of the team! 😛

    Oh, it's worse than that!

    Everybody knows that the...

    Rob Schripsema
    Propack, Inc.

  • RE: Happy Holidays

    george sibbald (12/23/2011)


    was torn between reindeer and turkey, but knowing that americans eat turkey at thanksgiving guessed right.

    so what do americans traditionanlly eat at christmas?

    With Christmas being much more internationally...

    Rob Schripsema
    Propack, Inc.

  • RE: ANSI_PADDING

    Great question -- especially the quirk involved when using 'LIKE'.

    Thanks!

    Rob Schripsema
    Propack, Inc.

  • RE: What else have you done?

    My list....

    General dairy farm labor (lots of manure)

    General chicken/egg ranch labor (more manure)

    Soda jerk (as in ice cream sodas, OK?)

    Furniture mover

    More farm labor (apple orchards)

    Psychiatric hospital aide (more manure)

    EFL (English...

    Rob Schripsema
    Propack, Inc.

  • RE: Variant Order 2

    Great question. Not what I would have expected....but then, many aspects of SQLVariants are not what I would expect.

    Rob Schripsema
    Propack, Inc.

Viewing 15 posts - 76 through 90 (of 241 total)