Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 2,838 total)

  • RE: Tally Table Uses - Part I

    Jeff Moden (8/2/2010)


    Stefan Krzywicki (8/2/2010)


    I do appreciate the suggestion, but I'm going to let it stand. I can't count the number of times I've read code or a coding technique...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Tally Table Uses - Part I

    Jeff Moden (8/1/2010)


    It IS interesting to see what folks do with the Tally Table or the "pseudo cursor" methods that are used to build it.

    Nice article and lot's of code...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Tally Table Uses - Part I

    Jeff Moden (8/2/2010)


    Heh... pretty low marks for the article so far, Stefan. Although I certainly appreciate what you tried to do both in your code and for the Tally...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Tally Table Uses - Part I

    Jeff Moden (8/1/2010)


    It IS interesting to see what folks do with the Tally Table or the "pseudo cursor" methods that are used to build it.

    Nice article and lot's of code...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    GilaMonster (7/31/2010)


    Alvin Ramard (7/31/2010)


    GilaMonster (7/31/2010)


    It's Sunday 1am and I'm recovering a 120 GB sql database from a month old backup and a collection of flat files. DBA? We don't need...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Looks like you gave him some good advice, Alvin. I hope he's already been googling until his retina burn, that's how I get up to speed on anything I don't...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Alvin Ramard (7/31/2010)


    GilaMonster (7/31/2010)


    And for the weekend...

    Please do my work for me: http://www.sqlservercentral.com/Forums/Topic961690-391-1.aspx

    Want someone to email questions to: http://www.sqlservercentral.com/Forums/Topic961691-1550-1.aspx

    I have 2 new SQL servers. What should I do? http://www.sqlservercentral.com/Forums/Topic961717-1549-1.aspx

    Am outa...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/28/2010)


    Brandie Tarvin (7/28/2010)


    GilaMonster (7/28/2010)


    So far this week I've seen two different people advocating backing the log up in Simple recovery.

    <*headthunk*>

    No.

    <*headthunk*><*headthunk*>

    Please no. Stop the pain!

    Stop hitting your head on...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/23/2010)


    Okay everyone, the hardest thing I have had to do since I started here (work) a little over 5 years ago is done, now the countdown to a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Incompetent or Malicious

    Steve Jones - Editor (7/22/2010)


    Certainly didn't seem like a Buddhist way of handling an issue in the story 😛

    I think you want this LUN: http://en.wikipedia.org/wiki/Logical_Unit_Number

    It certainly didn't!

    Yeah, I kept googling...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Incompetent or Malicious

    I had no idea what a LUN was, so I googled San Lun.

    What'd I get?

    http://en.wikipedia.org/wiki/San-Lun

    Apparently it is a Chineese school of Buddhism.

    I don't think that's what was causing the problem...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: database dropped -- recovery????

    raamaakrishna (7/21/2010)


    Hi guys, I am in serious problem. Some one hacked my sql server 2008 and dropped my database. How can I restore, I do not have any backup... Please...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (7/20/2010)


    Perhaps a BBQ tour is in order.

    Lynn, I didn't know it was possible to have a BBQ sandwich that WASN'T pulled pork.

    There's also...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Grant Fritchey (7/15/2010)


    I think we've shot past denial and are moving in the direction of outright insanity on this. I'm still reading it because it's like watching a car crash.

    I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (7/13/2010)


    Stefan Krzywicki (7/13/2010)


    Jeff Moden (7/13/2010)


    CirquedeSQLeil (7/13/2010)


    Here's another one in the same doc.

    As a rule of thumb, once a table has more than five indexes, updates to that table may...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 2,716 through 2,730 (of 2,838 total)