Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 3,669 total)

  • RE: Hidden RBAR: Triangular Joins

    I have my red-light questions that fire off warning bells for me.

    Any DBA who does not know what a temporary table or table variable is.

    Any DBA who can't see why...

  • RE: Hidden RBAR: Triangular Joins

    Heh.. dang, David... you might even be older than me! 😉

    Thanks a bunch. I'll start saving for a mid-life crisis. Oh hang on, interest rates have gone to...

  • RE: Moving Tables and Indexes to Filegroups En Masse

    I wasn't sure about the benefits of MOVE TO until I did a drop constraint and then inspected the table.

    The data had shifted onto the desired filegroup so I would...

  • RE: Hidden RBAR: Triangular Joins

    I understand the argument about not developing for 6 million products because getting a product to market, even with diminished functionality, will allow you to grab the high ground.

    I disagree...

  • RE: Hidden RBAR: Triangular Joins

    The temptation is to never revisit code that is working.

    This is my big concern with agile development. "We will deal with it in the next itteration". ...

  • RE: Hidden RBAR: Triangular Joins

    I've been playing with SSIS recently and have a love/hate relationship with it.

    I've a feeling that some of the facilities do RBAR type operations rather than set based operations.

    I know...

  • RE: A Dearth of Comments

    Have any of you guys heard of "information mapping"?

    I believe it is a trademarked approach. I used to work for a company that produced tehnical manuals and was given...

  • RE: A Dearth of Comments

    Steve Jones - Editor (1/8/2009)


    How long did it take you to figure it out, David?

    Some of it I didn't figure out, other bits I could remember who was likely...

  • RE: A Dearth of Comments

    In the past 10 days I have been bitten by the "no documentation" ghoul.

    If you have too much you can prune it, if you have too little then what do...

  • RE: A Dearth of Comments

    I am a fan of Innovasys DocumentX, although Red-Get SQL Documentor or APEX SQL Doc will do just as well.

    What's hard about adding a summary, remarks, returns, parameter details and...

  • RE: Industry Experience... Required?

    I can think of a few occassions where my knowledge of a particular industry has helped me in a different position.

    You can be a good DBA with no industry specific...

  • RE: Linked tables

    Sounds like you want a 3 table design.

    1. A "Tests" table holding your header information

    2. A "Measuring Points" table holding that items that could be applied to each test.

    3....

  • RE: Fast Project Rollbacks

    doobya (10/22/2008)


    Some very nice techniques and ideas in the article

    But I have never rolled back a change to a production database in 10 years.

    I rarely have to roll back a...

  • RE: The Financial Crisis

    The average annual salary in the UK is around 24K. Some of the bankers in the city get bonuses that mean Mr average would have to work for 100...

  • RE: Database Health

    In my environment we have a whole raft of health check reports and alerts

    • Disk space
    • Tables nearing the limit of their identity range
    • Failed jobs
    • Databases that will need to grow. We...

    Viewing 15 posts - 2,086 through 2,100 (of 3,669 total)