Forum Replies Created

Viewing 15 posts - 1,996 through 2,010 (of 2,443 total)

  • RE: Common questions asked in SQL Server DBA Interview

    jeffrey yao (6/22/2009)


    I dare say if a data model needs to be tested under rigorous cases, the data modeler will "consciously" or "unconsciously" conform to normalization requirements. By "unconsciously", I...

    ---------------------------------------------------------
    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: Common questions asked in SQL Server DBA Interview

    GilaMonster (6/19/2009)


    One I asked once (in an interview for senior position) was how to repair a torn page without losing any data. Anyone want to guess the answer I got?

    Gail,...

    ---------------------------------------------------------
    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: Going Native

    Charles Kincaid (6/19/2009)


    We went to the DIY store an bought a bunch of cheap thermostats. One in each room and several in the large gathering rooms. They are...

    ---------------------------------------------------------
    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: My Approach to Writing for SQLServerCentral

    zooomer (6/19/2009)


    practise is spelled practice.

    The first letter of a sentence should be capitalized, and when quoting, double quotes should be used.

    C'mon, really?

    ---------------------------------------------------------
    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: My Approach to Writing for SQLServerCentral

    I think I just paid a thousand bucks or so for this information in a college-level writing course. 😉 Very nice article, easy to read and excellent advice.

    Thanks!

    Jon

    ---------------------------------------------------------
    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: How do i get clients who have been enrolled for 12 months continously.

    don't make it too hard, dump all your records into a table ordered by client and then effdate, including an identity column and a flag for continuouslyEnrolled

    self-join, where the tableA.ID...

    ---------------------------------------------------------
    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: The Simple Estimate

    Bob Griffin (6/17/2009)


    Nicole Garris (6/16/2009)


    They pay us a lot of money to develop applications, design databases, etc. Once its simple, they will pay someone else a lot less.

    Amen to that!

    not...

    ---------------------------------------------------------
    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: Help with CASE statement.

    Might be beating a dead horse, but be sure you are evaluating your conditions in the right order. Best answer below is '@x=1 AND @z=3', but that is evaluated after...

    ---------------------------------------------------------
    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: Grouping problem

    . . . and then there are the unfortunate few who keep seeing you lob out these answers, but are still anxiously awaiting 2005 servers. Luckily everyone seems to be...

    ---------------------------------------------------------
    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: Are the posted questions getting worse?

    Tom Brown (6/18/2009)


    I had a short stint working for the marketing manager of a hospitality retailer. He often got free samples of the various offerings of breweries, wine merchants,...

    ---------------------------------------------------------
    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: Are the posted questions getting worse?

    Spoiled grapes, blech! Whiskey for me, thanks.

    ---------------------------------------------------------
    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: Back to the Future

    KevinC. (6/12/2009)


    I have an identical twin brother. We have basically the same interests but have taken divergent paths. I sometimes wonder where I would be if I had...

    ---------------------------------------------------------
    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: Back to the Future

    RBarryYoung (6/12/2009)


    I wish I'd spent more time at the office.

    Damn, now I'll never be able to use that phrase again - "You'll never hear anybody say . . ."

    ---------------------------------------------------------
    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: Back to the Future

    I wish I hadn't blown five years of college on a Jazz Performance degree that I now don't use, as much fun as it was. (decided not to move to...

    ---------------------------------------------------------
    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: How to Post Performance Problems

    Will be adding to my sig, for sure. 😀

    Thanks, great job!

    Jon

    ---------------------------------------------------------
    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 - 1,996 through 2,010 (of 2,443 total)