Forum Replies Created

Viewing 15 posts - 2,026 through 2,040 (of 3,669 total)

  • RE: Question about non SQL software

    Was it described as software that could query mixed datasources in situ?

    To me it sounds like some form of ETL system that can merge data from several systems into a...

  • RE: Accidently Agile

    My first exposure to agile lead me to think of it as the bodge it and wing it methodology. It fundamentally isn't. It isn't even a methodology, it...

  • RE: MySQL Primer for the SQL Sever DBA

    The thing that impresses me most about MySQL are the MySQL tech staff. These are a bunch of guys I consider myself privileged to have worked with.

    The trainers were...

  • RE: mdf Shrink fails - have tried everything possible..

    I would be surprised if it was the FKs that made the difference. I suspect it was the clustered keys primary or otherwise.

    I have run into this problem on...

  • RE: Accidently Agile

    I've just been reading "The Mythical Man Month" by Fred Brooks. Some people think his book is brilliant other people deride it with comments such as "it taught me...

  • RE: Accidently Agile

    For me the most important thing about "agile" is that it emphasise communication and that the best communication is face to face.

    Short itterations mean that developers and business people get...

  • RE: Don't Build a Monitoring System

    If I am a fan of a tool then I have no qualms about pushing that tool regardless of who produces it.

    There will always be people who complain about a...

  • RE: GUID or Int is the best for primary key columns?

    The advantages of partitioning where only one filegroup is used is in the simplicity of splitting, merging and switching partitions to achieve a rapid delete of a large volume of...

  • RE: Accidently Agile

    I've seen that this article is going to be published again in the 3rd week in September 2009. A great deal has changed in the 18 months since I...

  • RE: DBAs and the Art of Diplomacy

    It depends on the personality of the person you are speaking to.

    Some managers view any resistence as dissent to be crushed. A carefully phrased question can start a productive...

  • RE: Database Documentation Using Red Gate's SQLDoc

    It isn't as complex as it looks. The complexity is in having to rename directories as a result of the timestamp facility but Red-Gate have that down as a...

  • RE: Intersect, Except, Union, All and Any

    I didn't include UNION because I could not think of an alternative to the UNION statement that didn't involve creating temporary tables.

    INTERSECT and EXCEPT can be modelled with joins and...

  • RE: Intersect, Except, Union, All and Any

    In the graphical execution plan if you move the mouse pointer over the left hand graphic the costs are revealled.

  • RE: GUID or Int is the best for primary key columns?

    The problem with a compound key where one of the fields is a ServerId is when you are running a disaster recovery site.

    You have to remember NOT to synchronise the...

  • RE: Changing from individual databases to one huge multi-schema database

    True Paul but the trick is to work out if you actually need those features and if not, why pay for them.

    You wouldn't try and run your entire operation on...

Viewing 15 posts - 2,026 through 2,040 (of 3,669 total)