Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 3,348 total)

  • RE: Query Tuning

    Jeff Moden (12/28/2011)

    SQL Kiwi (12/28/2011)

    (and no-one reads these comments anyway :-))

    Just the important ones. 🙂 Glad you and Hugo stopped by. I made a pretty bad mistake...

    December 28, 2011 at 5:25 am

    #1426032

  • RE: Query Tuning

    tabinsc (12/27/2011)

    I do have one question: If clustered index columns are auto-appended to nonclustered indexes, what if the nonclustered index is unique? Adding the clustered index column(s) to...

    December 27, 2011 at 3:59 pm

    #1425897

  • RE: Query Tuning

    440692 I am just a number (12/27/2011)

    Could you expand on the explanation for option E

    Several people asked this. The answer is that the SARGability of the ISNULL is irrelevant, because...

    December 27, 2011 at 3:53 pm

    #1425894

  • RE: Query Tuning

    Hugo Kornelis (12/27/2011)

    EDIT: After looking at the question in yet a bit more detail, I realise that the ability to rewrite the ISNULL is completely irrelevant to the question. The...

    December 27, 2011 at 3:39 pm

    #1425892

  • RE: Query Tuning

    Thanks for a great question, Jeff!

    I had it wrong, for two reasons:

    1. Not knowing that the optimizer is smart enough to rewrite an ISNULL of this form to a SARGable...

    December 27, 2011 at 3:22 pm

    #1425889

  • RE: Output Parameter

    malleswarareddy_m (12/22/2011)

    if there was no index defined than the results will returned in the order in which they were inserted right?

    Like I just said, that will usually be the case....

    December 22, 2011 at 5:56 am

    #1424742

  • RE: ANSI_PADDING

    Pawel Borkowski (12/22/2011)

    I did it but it returns 4,4,3.

    You might want to double check the code you typed, and compare it to the code in the original question. Pay extra...

    December 22, 2011 at 2:48 am

    #1424641

  • RE: Output Parameter

    malleswarareddy_m (12/22/2011)

    I think the above result depends on the insert statement.which ever first inserted it is showing that only.Please clarify

    me if am wrong.

    You are somewhat right and somewhat wrong.

    The table...

    December 22, 2011 at 1:06 am

    #1424609

  • RE: Using sys.index_columns

    R.P.Rozema (12/20/2011)

    Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best...

    December 20, 2011 at 12:53 am

    #1423432

  • RE: ANSI_PADDING

    Thanks, Paul!

    I won't say "it all makes sense now" - but at least, I now have at least a passing chance of remembering what might have happened and where to...

    December 19, 2011 at 1:34 am

    #1422976

  • RE: ANSI_PADDING

    Thanks for the question, Jason.

    I only got it right because "3, 3, 1" was not in the answer options - that was the answer I was looking for after reading...

    December 19, 2011 at 12:53 am

    #1422971

  • RE: Concurrent Operations

    David Burrows (12/15/2011)

    Hugo Kornelis (12/15/2011)

    If you really want to test the statement made in today's question, you have to run the two backup commands from two seperate tabs in SSMS

    Out...

    December 15, 2011 at 3:06 pm

    #1422245

  • RE: Concurrent Operations

    msurasky-905715 (12/15/2011)

    We learn something new every day... questions like these humble the most arrogant DBAs...

    Having said that, I read in this discussion that the operations are indeed permitted in T-SQL...

    December 15, 2011 at 7:42 am

    #1421958

  • RE: Using SP_

    jcrawf02 (12/14/2011)

    I was under the impression that SQL always looked in master first for sp's and tables if you do not specify a schema, is that only true for sp_...

    December 14, 2011 at 7:26 am

    #1421283

  • RE: Variant Order 3

    (still off-topic)

    Tom, I fooled around a bit with both Bing Translator and Google Translate, and I am convinced that they both suffer from the same bug, introduced by a combination...

    December 14, 2011 at 1:10 am

    #1421070

Viewing 15 posts - 2,281 through 2,295 (of 3,348 total)