Forum Replies Created

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

  • RE: How many Records Will Get Selected

    An easy 3 points.

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

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

  • RE: What identity comes next?

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

    Good question. Thanks.

  • RE: SQL syntax

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

    Interesting info though.

  • RE: DDL trigger

    Great question, and for me, educational.

    Thanks,

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

  • RE: Geocode Addresses in T-SQL

    An excellent article, and very well written.

    Thanks

  • RE: The ORM Dilemma

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

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

  • RE: Analysing a T-SQL Query

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

    Good QotD.

    Thanks,

  • RE: Bad data import

    Very interesting.

    Thanks!

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

  • RE: Understanding and Using APPLY (Part 2)

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

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

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