Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 6,486 total)

  • RE: Should non-clustered indexes be placed on separate physical device than data?

    Grant Fritchey (9/3/2008)


    Disk operations working the way they do, more spindles is better than fewer. That's at least part of why SAN's (properly configured, propertly maintained, etc.) succeed so well....

  • RE: UPdate statement

    rbarryyoung (9/3/2008)


    Matt Miller (9/3/2008)


    rbarryyoung (9/3/2008)


    Because I put it in.

    That's why you keep seeing the old "the order of processing is not guaranteed" disclaimers on MSDN as to these kinds of...

  • RE: What to do with carrige returns?

    Your best bet might be to simply pick some sequence of characters that won't ever happen, and use that as your "carriage return". At which point you strip out...

  • RE: UPdate statement

    rbarryyoung (9/3/2008)


    Because I put it in.

    That's why you keep seeing the old "the order of processing is not guaranteed" disclaimers on MSDN as to these kinds of things. Depending on...

  • RE: innerjoin between 3 table columns

    anithareddyg1 (8/25/2008)


    Thank you,

    joining different columns in 3 tables using innerjoin.

    once again thankyou.

    Jack just gave you an example for a three-table join - is that what you need? There are...

  • RE: If You Ain't Cheatin'

    blandry (8/25/2008)


    Consider...

    "Failures are the guideposts on the road to success and every great invention in any arena had to be reached by the trial and error of the failure process."

    If...

  • RE: The Starting Point

    thelabwiz (8/11/2008)


    "If I could get drivers for the laptop, I'd go back to XP."

    I do software development for some niche devices and there are enough glitches with these tools under...

  • RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

    I realize I'm getting to the party late (you know - after Billy spiked the punch and got expelled for mooning the principal), but - isn't the PIVOT syntax available...

  • RE: Oxymorons!Fun on a Friday

    rbarryyoung (8/21/2008)


    Adrian Nichols (8/21/2008)


    If you're going to exaggerate, at least do it in style... "Today, I'm going to give 325%, that's right three and a quarter times that of everyone...

  • RE: T-SQL Challenge, One row to Many based on Quantity

    John -

    It sounds to me that you want to use a Tally table. it will allow you to return the desired amount of rows needed.

    Here's a good primer...

  • RE: White Space In SQL Server 2005

    Are you SURE that is in fact a blank space on the initial server, and not some non-printing character?

    According to Books Online, the len() function....

    Returns the number of characters of...

  • RE: DBA as commodity in future

    jeffrey yao (8/15/2008)


    To be honest with you, Vivien, whenever I see requirements like

    Vivien Xing (8/14/2008)


    * Expertise covering a broad range of specialized skills

    * In-depth project management, vendor management, and...

  • RE: Hidden RBAR: Triangular Joins

    toniupstny (8/15/2008)


    (** adding: in response to Charles **)

    Hmmm.... I (re)read the article Jeff pointed to as the follow-up

    Heh... it's been out for quite some time...

    http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

    --Jeff Moden

    and frankly did...

  • RE: My 3rd party softwares uses tons of cursors.

    Matt Miller (8/14/2008)


    I will see what I can do. I think I might want to try a CLR proc on this one.....

    By the way - that was a "sure...

  • RE: A Release from Data

    Ted Pin (8/14/2008)


    gunna48 (8/14/2008)


    Nice to know I'm not the only martial geek out there. And I agree with Grant sparring with a love body or more is much more stress...

Viewing 15 posts - 2,626 through 2,640 (of 6,486 total)