Forum Replies Created

Viewing 15 posts - 76 through 90 (of 240 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....

  • 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....

  • 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...

  • 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....

  • RE: SQL Agent Roles

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

  • 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...

  • 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...

  • 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...

  • RE: Tail Log Backups

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

  • 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...

  • 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...

  • 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...

  • RE: ANSI_PADDING

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

    Thanks!

  • 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...

  • RE: Variant Order 2

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

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