Forum Replies Created

Viewing 15 posts - 2,326 through 2,340 (of 2,443 total)

  • RE: Thank You All

    I have to second James' thanks, and I'm sure there are many others who feel the same and just don't say it enough. With the knowledge I've gained here at...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Patindex

    Wayne West (9/17/2008)


    Jeff Moden (9/16/2008)


    ... The real key is that I have a good friend that I argue with/agree with once in a while. He said something I'll never...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Patindex

    Carla Wilson (9/12/2008)


    Thanks for testing and comparing the performance of PATINDEX, LIKE and CHARINDEX! You've inspired me to test some of my procedures. Looks like they could benefit...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Happy Birthday

    Happy birthday, Steve!

    At the moment, I'd say a Kindle http://www.sqlservercentral.com/articles/Editorial/62941/ would be nice, although then I'd have to have time to actually use it. Tools would be good, but like...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Legal Liability

    David Reed (9/11/2008)


    I also worked for an IP law firm that did a lot of suing back in the '90s, and the bill rates were nice. Does that make me...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: If You Ain't Cheatin'

    Steve Jones - Editor (9/11/2008)


    Mark,

    The problem is that this guy might have been "successful" as a DBA at his last job. Perhaps another group ran backups using Tivoli or something...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Patindex

    Your solution works if the original set is small, like your example of 'January:February:March', but as you pointed out, gets ugly the larger your string gets.

    Two things -

    1)...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Legal Liability

    IceDread (9/11/2008)


    "idiocy can NEVER be a crime"

    I dissagree. Ignorence or idiocy can never be used as an excuse to commit a crime. It is your responsibility to know the law...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Legal Liability

    I got mugged at the grocery store this morning, and it's the police chief's fault, because he wasn't there to stop it. Actually, it's the security guard's fault, because he...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: SQL in Latex

    timothyawiseman (9/6/2008)


    What is the best way to format SQL in Latex?

    Spackle first to fill in any holes, sand, prime and then use a roller with a 3/8 inch nap. And...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Collaborate or Eliminate ?

    Steve Jones - Editor (9/8/2008)


    You have to try and collaborate, try and help, but at the same time you have to meet your responsibilities.

    Management has to see this, perhaps by...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: NOLOCK Discussion

    Ok, so I've seen some half-answers to this question, but my pea-brain needs a clear response to this:

    I'm working in an environment where the reporting server is only updated once...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: An IT Union - Database Weekly (Sept 8, 2008)

    David Reed (9/8/2008)


    ¡¡What a great way to encourage more outsourcing!! :w00t:

    Maybe I should've wrapped that in sarcasm tags, since not everybody recognizes the sarcasm mark.

    That's always the argument against organization,...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Odd Construct in a WHERE clause

    GilaMonster (9/4/2008)


    If the data is not changing a lot, then you are probably not running into lock waits and hence nolock won't help much. Nolock is not a silver bullet...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Pass file name as variable

    It looks from your initial few posts that the filename will actually be something like File20050801.txt, where you're incorporating the date. If that is true, and the date will always...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 2,326 through 2,340 (of 2,443 total)