Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 3,678 total)

  • RE: Auto-suggesting foreign keys and data model archaeology

    Bill Talada (1/26/2016)


    As for guids, I switched all int keys to guids on a large database and got a general 20% improvement in speed. I'd guess a 64 bit...

  • RE: Auto-suggesting foreign keys and data model archaeology

    The trick here was to try to encapsulate what a human would do but in code.

    If you do this sort of thing once in a blue moon then manual approaches...

  • RE: DeveloperBall

    I play badminton and have seen a low ranked pair beat a far more skilled opposition simply because the no-hopers worked well together.

    I've seen various personality assessment schemes such as...

  • RE: DeveloperBall

    Teams are so complex! People with similar personalities may work well together or they may clash.

    Some of the oddballs end up being the binding force within the team.

    I'm not sure...

  • RE: Design a Better SQL Server Pricing Model

    The editions are just away of charging what the market will bear. It's like discount coupons. It let's a company broaden its potential customer base with and artificial...

  • RE: Design a Better SQL Server Pricing Model

    larsjessenhh (1/21/2016)


    If you had ever the fun to deal with the advanced quantum mechanics of oracle licensing you're really happy with the 'all inclusive' approach of sql server.

    Have you come...

  • RE: Muting the Immutable

    I can understand doing this for a very limited number of datasets. I think it would create problems for Kimball data warehouse systems where we need slow changing dimensions....

  • RE: Turn Out the Lights

    People want craftsmanship if they don't have to pay for it. They're prepared to pay for flat pack quality that will last until they are in a new job

  • RE: Turn Out the Lights

    Andy, it's not just that it is an expense it's whose expense it is.

    The instant it becomes and IT expense non-IT loses interest. If IT identifies the problem and...

  • RE: I thought my database was collation agnostic

    There used to be a bug in the cluster install of SQL2008R2 that set the collation for the server incorrectly no matter what you specified. I'm not sure if...

  • RE: The Ongoing Costs of Building Software

    In my world buy vs build raises the question of who integrates the solutions and what is required to enable that to happen.

    If you build it then could you sell...

  • RE: 100 Hours

    It depends what your base knowledge is and whether you understand the fundamental principles.

    If you don't understand the principles you will be learning by rote and unless you are one...

  • RE: The SQLite alternative to NoSQL

    There are so many NOSQL solutions that it is easier to say what NODQL is not than what it is.

    As a data architect one of my great frustrations was solutions...

  • RE: Running as SysAdmin

    Jeff Moden (1/2/2016)


    Perhaps it's time to start listening when a person gets to the point of citing incompetence of others because they only get to that point after they've given...

  • RE: Find Missing FK Constraints and Fixing them

    Nearly finished my solution to this. Turns out to be far more involved and have loads of gotchas than a casual approach would reveal.

Viewing 15 posts - 1,381 through 1,395 (of 3,678 total)