Forum Replies Created

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

  • RE: Queries

    Koen Verbeeck (11/28/2012)


    The only correct answer is 0.

    There are 8 statements in the estimated execution plan, but no queries.

    From BOL:

    A query is a request for data that is stored in...

  • RE: File Tables

    demonfox (11/19/2012)


    After reading the file table, I fell on varbinary(max) ..

    need to read it again ..

    thanks for the question..

    +1 🙁

  • RE: Enable Database Mail in 2012

    The extra point is good! 😀

  • RE: LEAD - 1

    demonfox (10/30/2012)


    oh , I got it wrong , I thought instead of null, it will give default 0 as output..

    ..

    learned something though 😉

    thanks for the question...

    +1

    I also thought it would...

  • RE: Parsing values in the WHERE clause

    Nice and interesting question to start the week, thanks.

  • RE: PARSENAME

    Learned something new today, not sure I'll ever need to use it, but you never know.

    Thanks for the good question. 😀

  • RE: Table Variables

    I got it wrong, you can have multi almost everything except rowguid (which is the only one I got right)... ah well... good question though my brain hurts 😀

    ...and just...

  • RE: VIEW - 9

    I'm not very offay with Views, not used them much at all.

    However after the last question like this I knew it needed that clustered index so got the answer right...

  • RE: While loop 2

    Darn! Saw the question, and for a few various reasons I thought it was the same question as the last time, and presumed a mistake with SSC or caching or...

  • RE: FTS

    Good question thanks.

  • RE: DECLARE - 1

    Good back to basics question thanks, although I'm sure we've had previous on this topic.

    Keep posting them though. 😀

  • RE: APPLY - 2

    Good and interesting question for a Monday, thanks.

  • RE: Transactions

    Gaarrr!!! :angry:

    Even though I knew the answer was "Success, Fail, Success" for some dumb @ss reason I clicked the inversion and selected "Fail, Success, Fail" aaaaargh!!

    :w00t:

  • RE: Tracking Processes

    I'm a bit late to this party as the SSC daily email was blocked by our server due to profanity... :w00t:

    I got this "right" but I fundamentally agree with the...

  • RE: Extended Events I

    Nice question for a Monday, quite straightforward. Thanks

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