Forum Replies Created

Viewing 15 posts - 2,746 through 2,760 (of 3,348 total)

  • RE: Split string using Tally Table

    jts_2003 (7/2/2010)


    I think this is an example of why people don't like to use OVER, since it's so hard to work out what might/will be returned!

    I'd like to see a...

  • RE: Split string using Tally Table

    I got it right, by focusing on the WHERE clause (that alone dictates the number of rows), and hoping that there was no parentheses mismatch or similar error buried in...

  • RE: PRINT vagaries

    krishnaroopa (7/1/2010)


    Also, why not it work like this:

    '-' being string,

    other two can implicitly convert to string?

    They can, but they won't. SQL Server uses well-defined rules for data type precedence...

  • RE: Disable All Triggers

    hrvoje.piasevoli (7/1/2010)


    But that does not make this the recommended method to disable all triggers in a database. As can be read in the documentation that is referenced in the explanation,...

  • RE: Disable All Triggers

    Given the answer options, I agree that the sp_foreachtable option was the only correct one.

    But that does not make this the recommended method to disable all triggers in a database....

  • RE: PRINT vagaries

    Open Minded (7/1/2010)


    I think MDAS is also followed when there are a bunch of operators between numbers. I guess 'select 6+2+-+7' became 1 happened in this manner:

    • . 6+2+-+7...

  • RE: PRINT vagaries

    Good question. The only thing I dislike about it is the description "PRINT vagaries" because, as others have noted, the PRINT statement is completely innocent.

    A better name would have been...

  • RE: What will be the output of the following?

    hilld (6/29/2010)


    Ok, they changed the question. How do I change my answer now?

    You can't. You always have to check the question on the website before answering. I believe there...

  • RE: What will be the output of the following?

    hilld (6/29/2010)


    It still says that -1,0,1 is wrong.

    I've said it before, I'll say it again - the question has been changed.

    Read the changed text of the question on the website....

  • RE: TDE and Tempdb

    mzettler (6/29/2010)


    I'm a bit confused with the answer to be honest. I saw the reference article and followed the link concerning the tempdb (http://msdn.microsoft.com/en-us/library/ms190768.aspx) where it explicitly said the encryption...

  • RE: TDE and Tempdb

    I, too, chose the "none of the above" answer.

    In addition to the links already posted by other contributors, here is a third one:

    "Microsoft has estimated the entire impact of TDE...

  • RE: What will be the output of the following?

    paul s-306273 (6/29/2010)


    Perhaps we need some Quality Control on QOD.

    Changing the question after people have started submitting answers - that seems a bit unfair to me...

    Maybe you should read the...

  • RE: What will be the output of the following?

    sunitagaikwad (6/28/2010)


    i am getting -1, 0, 1

    how come u r getting -1,-2,-3 ? pLz explain.......

    There was a typo in the question, that has been corrected after the newsletter was sent...

  • RE: What will be the output of the following?

    kevin.l.williams (6/28/2010)


    Sorry if this was already covered. I did read through the 11 pages :doze: and didn't see much on the subject of sort order. Without a specified order wouldn't...

  • RE: What will be the output of the following?

    Duncan Pryde (6/28/2010)


    Changing the subject somewhat...

    Although I knew that you can have negative seeds and increments for the IDENTITY property, I've never actually used them myself.

    I'd therefore be interested to...

  • Viewing 15 posts - 2,746 through 2,760 (of 3,348 total)