Forum Replies Created

Viewing 15 posts - 7,456 through 7,470 (of 8,416 total)

  • RE: Performance Question

    In fact I'll do it for you. Actual execution plan attached.

    Note that the @MaxGen tuning parameter is deliberately set low - at 100 - to allow the script to...

    July 10, 2009 at 3:48 am

    #1022920

  • RE: Performance Question

    Peso (7/10/2009)

    The checksum can be considered "Good enough".

    So it's not a "BAD choice" any more then? 😀

    Peso (7/10/2009)

    But you still will have to compensate for the duplicates; ie delete the...

    July 10, 2009 at 3:33 am

    #1022915

  • RE: Need to improve performance of multi million record table with calculated columns

    mayurbvb (7/9/2009)

    In addition to this I'm also adding up 15 new calculated columns to the same SQL Server table which are used in multiple reports developed. I'm adding indexes to...

    July 10, 2009 at 3:24 am

    #1022905

  • RE: Performance Question

    Hey Dave,

    Your logic also applies to the hash_code calculated on my UniqueCodes table as well - since the hash is for the code column which is VARCHAR(10).

    In my current UniqueCodes...

    July 10, 2009 at 3:12 am

    #1022899

  • RE: Performance Question

    Peso (7/10/2009)

    But why suggest an alternative that returns an error saying "Sorry mate, couldn't create as many codes as you wanted." This behaviour wasn't there before and why introduce...

    July 10, 2009 at 2:19 am

    #1022888

  • RE: Performance Question

    Peso (7/10/2009)

    It's not the function that takes time here.

    It's the LOOP.

    That has already been covered in a previous post.

    It rather misses the point anyway - there is no need for...

    July 10, 2009 at 1:37 am

    #1022871

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    RAISERROR()? CHECKSUM()? They're both T-SQL though.

    CHECKSUM! Awesome!!! Thanks - exactly what I was looking for - I can relax now...

    @Wayne: A special...

    July 9, 2009 at 7:36 pm

    #1022823

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    [font="Verdana"]Hmm. Do you include the variable number of columns in the ranking functions? Other than those, I can't think of another off-hand. Perhaps you...

    July 9, 2009 at 6:24 pm

    #1022808

  • RE: Comparing Table Variables with Temporary Tables

    Wish (7/9/2009)

    Inside one of my SP, I am storing values in table variable to loop through the records.

    If number of records inserted in table variable is too high(May be in...

    July 9, 2009 at 5:24 pm

    #1022785

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    do you really think the question is faulty?

    [font="Verdana"]Well, COALESCE is a SQL standard function, not just T-SQL. So perhaps the question is... mis-directed?[/font]

    Ok....

    July 9, 2009 at 4:34 pm

    #1022770

  • RE: Some forum issues fixed

    Mel Harbour (7/9/2009)

    Finally, part of what I will be looking at in the coming months is the ways in which we can improve SQLServerCentral. We are taking a pretty wide...

    July 9, 2009 at 4:32 pm

    #1022769

  • RE: Are the posted questions getting worse?

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    Question:

    Is COALESCE the only function in T-SQL that can accept a variable number of parameters?

    If so, why?

    [font="Verdana"]Mu.

    Had to edit that because with Wingdings as the...

    July 9, 2009 at 4:19 pm

    #1022758

  • RE: Are the posted questions getting worse?

    Question:

    Is COALESCE the only function in T-SQL that can accept a variable number of parameters?

    If so, why?

    July 9, 2009 at 4:02 pm

    #1022747

  • RE: CLR TVF-: how can we send the optinal parameter

    Florian Reischl (7/9/2009)

    Nope. I meant optional parameters with default values like often done in C++ or VB6 (don't know if VB.NET supports this feature any more). The "params" enables you...

    July 9, 2009 at 4:00 pm

    #1022746

  • RE: Are the posted questions getting worse?

    Florian Reischl (7/9/2009)

    Bruce W Cassidy (7/9/2009)

    Paul White (7/9/2009)

    Ah - so you are a fan of anti-verbositization then :w00t:

    [font="Verdana"]If only mere words could express my floccinaucinihilipilification of verbiage...[/font]

    :unsure:

    floccinaucinihilipilification

    Anyone else notice the...

    July 9, 2009 at 3:54 pm

    #1022745

Viewing 15 posts - 7,456 through 7,470 (of 8,416 total)