Forum Replies Created

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

  • RE: Error messages

    Great QoTD! Thanks.

    Two concepts were revisited at the same time.

  • RE: Parallel Plans

    Damn, I misunderstood the question.

    I thought which of those options were actually true but not combined.

    Either way I would have guessed wrong. 😀


    Thanks for the question.

    Learnt something new today.

    If only we could use variables as object names in other places, my life with MSSQL would be a lot easier. 🙂

  • RE: Whats going on Query window?

    Thanks for the question.

    I didn't get it right but then I'm not a human SQL parser. :w00t:

  • RE: Getting the Most out of Statistics

    Very concise and informative. Thank you.

  • RE: A Questionable Trigger

    Sorry but this QotD was too confusing. 🙂

    Nowhere does its author states that he has execution plan options enabled.

    And an UPDATE command returns no resultset (unless we use the OUTPUT...

  • RE: Valentines Day

    I would choose both first and last answers. 😀

  • RE: Full Text Search - Neutral Language - Can't figure out why

    Sorry, guys. That doesn't explain my problem well.

    I made an example which is exactly what's happening.

    I appreciate any help since we have an SLA deadline with our customer and I...

  • RE: Truncate

    I chose the obvious answer and got it wrong.

    That's very interesting to know.

    I wonder how other DBMS's would behave...

  • RE: Making a copy of a table.

    I'm thinking of the Generate Scripts Wizard feature here.

    Couldn't you do a smart replacing in a text editor to change the part of the index's name the mentions the table's...

  • RE: Assigning categories to values 1

    I totally failed reading the "BETWEEN -1 AND -10" part.

    Thank you, Hugo. Awesome question.

  • RE: COUNT() Function

    Rose Bud (4/18/2013)

    Personally, I don't mind when the person who posted the question admits there is a gap in their understanding. I know the SSC community will fill it...

  • RE: Triggers 1

    I knew it had to do with the batch but I ended up choosing "0" as in "the whole batch will fail". Stupid me. 😀



    I thought that the second SET IDENTITY_INSERT would automatically set the TblA1 property off. But it actually gives an error.





    I was kinda confused because...

  • RE: File Tables

    61% chosen - It is used in conjunction with the FILESTREAM data type;

    It seems many people had the idea that FILESTREAM is a data type and not a column property.


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