Forum Replies Created

Viewing 15 posts - 1 through 15 (of 178 total)

  • RE: User with total points more than 30000?

    vivekjamshedpur (8/16/2013)

    http://www.sqlservercentral.com/TotalScores.

    The above link is not valid

    How is it not valid, it is the link supplied at the bottom of every answer on QotD... I don't see the explanation...

    August 16, 2013 at 5:29 am

    #1642096

  • RE: User with total points more than 30000?

    Toreador (8/16/2013)

    DugyC (8/16/2013)

    as of now there are 3 people with more than 30,000 points and they are all showing as SSCChampion

    If you follow the link given in the explanation you...

    August 16, 2013 at 4:47 am

    #1642076

  • RE: User with total points more than 30000?

    Regardless of what a single forum thread says, as of now there are 3 people with more than 30,000 points and they are all showing as SSCChampion. Therefore that is...

    August 16, 2013 at 3:38 am

    #1642046

  • RE: Lock mode RangeI-N

    SQL Surfer '66 (8/2/2013)

    Stupid font (no offence to the question author). I started looking for RangeL-N. :crazy:

    +1 :doze:

    August 2, 2013 at 6:11 am

    #1638128

  • RE: Temp Table

    Tock (6/25/2013)

    Perfect question for the morning after a night with little sleep 🙂

    Cheers,

    Steve

    Unless you didn't read the question properly and skimmed the part about opening another query window... doh! :doze:

    June 25, 2013 at 8:00 am

    #1627129

  • RE: SHOWPLAN_XML

    Hugo Kornelis (6/13/2013)Given my utter lack of mindreading skills, I flipped a coin. And I got lucky this time, so I picked the correct answer. Which is a good thing...

    June 13, 2013 at 3:04 pm

    #1623913

  • RE: Event Notification on Server

    Danny Ocean (5/21/2013)

    i have no idea about this topic. I just guessed and got it right.

    Thanks for question 🙂

    +1 ...except I got it wrong :blush:

    May 22, 2013 at 9:36 am

    #1617492

  • RE: QUERY and TABLE HINTS

    call.copse (4/29/2013)

    I got it right by reading the documentation and assuming the question had been inverted by ascertaining that there were 3 official hints that did not require WITH, so...

    April 29, 2013 at 3:54 am

    #1610723

  • RE: LEFT JOIN

    Mighty (4/4/2013)

    Sorry to say that I also think that the wording of the answers is poor, and that the correct answer should be b.

    +1

    But it was a good attempt so...

    April 4, 2013 at 4:39 am

    #1603483

  • RE: SubQuery

    demonfox (3/7/2013)

    vinu512 (3/7/2013)

    The option is wrong....it is not necessary to have an Order By clause if Top is specified in a query.....it should be other way round.....Order By can only...

    March 8, 2013 at 2:31 am

    #1594862

  • RE: ISNUMERIC

    Don't really pay attention to the heading as it can often be misleading and just focus entirely on the detail of the question.

    I like these "gotcha" bug style questions, little...

    March 6, 2013 at 2:21 am

    #1593828

  • RE: Clustered Index

    Danny Ocean (3/5/2013)

    Very good question. For get a correct answer and point, you need to look as question very carefully.

    keep it up !!! 🙂

    +1

    Great question thanks

    March 5, 2013 at 1:04 am

    #1593304

  • RE: Can This Work?

    Fortunately I guessed right but I agree with all the comments above.

    Even assuming you were not referring to creating stored procedures in a batch, the answer for me was still...

    March 1, 2013 at 4:10 am

    #1592305

  • RE: Basic Date Function

    Hugo Kornelis (2/13/2013)

    I had almost missed the different time in the returned output, as I was focusing completely on the data type. Caught is just in time!

    I do not agree...

    February 13, 2013 at 4:04 am

    #1587347

  • RE: Thesaurus Files

    arun1_m1 (2/8/2013)

    That was a googly :w00t:

    +1 :Whistling:

    February 8, 2013 at 2:03 am

    #1585801

Viewing 15 posts - 1 through 15 (of 178 total)