Forum Replies Created

Viewing 15 posts - 2,746 through 2,760 (of 4,080 total)

  • RE: NC index on large table

    ishaan99 (7/15/2009)


    I have a table which get populated each time a user clicks on a page. This table is only used for running selects and has approx 74 million rows....

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Executing vb.net dll in sql server 2005 stored procedure

    I can't send you examples, but the proper terminology for calling external code from SQL is either "EXTENDED Stored Procedure" or "CLR (Common Language Runtime)". I...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Order By with Case statement

    I suggested that as an alternative. I assume that in his case, he wants to know the value that doesn't have a dash in it.

    But,...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    A bit of humor for those of you who own dice with more than six sides.

    http://xkcd.com/%5B/url%5D

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: sql trend line formula?

    Can you give us some context please? What problem are you trying to solve. Where did you hear or read the term "SQL Trend Line...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Selecting maximum distinct date by month

    To be very safe, remember to group by year and month, not just by month. Otherwise you will run into problems if your data spans more than...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Order By with Case statement

    The ORDER BY wants all values to be of the same datatype. Where you find a '-' in the string for ssid, such that a numeric value is...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Gail, I've heard slow code defended because:

    1. "It's more intuitive."

    2. "It reads better."

    3. "SQL figures all that stuff out."

    4. "That's how I...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Significance of Partitioning on Two Related Tables

    I wanted to avoid this because of the sheer size of the tables. Frankly, we don't have enough disk space to play with... but what else is...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    I'm just trying to add a little room for indoor plumbing, Alvin. 😉

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Significance of Partitioning on Two Related Tables

    Thanks, Gus, that makes sense to me, even though I was hoping to avoid it.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    (First Verse…. I need to get these all in order some day.)

    Let me introduce myself, the name’s James T. Kirk.

    A Federation starship is the place that I work.

    We fly to...

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    If I do... will that pay for the assistance?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Can anyone who has been through the partitioning wars give me some advice here?

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • RE: Are the posted questions getting worse?

    Mmmm.... pork chOPS. 😛

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 15 posts - 2,746 through 2,760 (of 4,080 total)