Forum Replies Created

Viewing 15 posts - 31 through 45 (of 321 total)

  • RE: How many Records Will Get Selected

    An easy 3 points.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: HAVING

    Rick Lang (6/7/2010)


    I'm missing something here. I get the same answer if I don't include the HAVING clause, so I'm not picking up on the value added of the...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Clearing the Transaction Log

    I think I almost got it right - 🙂

    This was a great question that made me do a little reading and learn something about a little understood part of SQL...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: What identity comes next?

    Tricky. I had a 50-50 chance and blew it!

    Good question. Thanks.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: SQL syntax

    I'm afraid I have to join the chorus in saying the question was poorly worded.

    Interesting info though.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: DDL trigger

    Great question, and for me, educational.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Simple LIKE with wildcard

    honza.mf (5/25/2010)


    jlennartz (5/25/2010)


    If all characters were inserted into DB as upper case how come query is returning lower case?

    It's another aspect of this question not mentioned yet: All characters inserted...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Geocode Addresses in T-SQL

    An excellent article, and very well written.

    Thanks

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: The ORM Dilemma

    I can't contribute much because you made me Google ORM. I guess I'll just follow the thread.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Getting Colorful

    I've always used SNL's "Not yet ready for Prime-time."

    If you've read through to here and missed "Fartware", go back and find it. The explanation is beautiful.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Analysing a T-SQL Query

    Got lucky and got the points, but mainly I learnt something.

    Good QotD.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Bad data import

    Very interesting.

    Thanks!

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Backups

    I did just take the cert exam, and I'm glad this one wasn't on it. I too thought that a full backup broke the log chain.

    Thanks for a good and...

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Understanding and Using APPLY (Part 2)

    I will be using APPLY beginning this week. Thanks for a really understandable series.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • RE: Model.mdb

    I wasn't sure of the answers so I looked it up. That makes it a good QotD even though 1 of the answers is suspect.

    Thanks,

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

Viewing 15 posts - 31 through 45 (of 321 total)