Forum Replies Created

Viewing 15 posts - 331 through 345 (of 820 total)

  • RE: The Worst Advice

    cs_troyk (7/10/2009)


    "Denormalize for performance" and its sibling "You only need to normalize to 3NF".

    That one only applies to the Compact Edition, IMHO. No, I mean for doing it. ...

  • RE: The Worst Advice

    I agree with what has been said so far. I am fearful of things that use words like always and never. I'd love to put my .mdf and...

  • RE: Documenting Database Code: Structured Headers

    Here are a couple of queries you can use to retrieve the descriptions.

    First SQL 2000

    SELECT

    sysobjects.name AS [Table Name],

    syscolumns.name AS [Column Name],

    sysproperties.value AS [Description]

    FROM sysproperties

    LEFT OUTER...

  • RE: Documenting Database Code: Structured Headers

    Here are a couple of queries you can use to retrieve the descriptions.

    First SQL 2000

    SELECT

    sysobjects.name AS [Table Name],

    syscolumns.name AS [Column Name],

    sysproperties.value AS [Description]

    FROM sysproperties

    LEFT OUTER...

  • RE: Documenting Database Code: Structured Headers

    Sorry David. I'm not going to try to mess with SSMS.

    I am working on a tool that lets me connect to the database, shows me a list of tables,...

  • RE: Raw Materials - Career Counseling

    Steve Jones - Editor (7/8/2009)


    Well I've seen them compared to prison cells, and often with less space in the cubes!

    At least there is a crapper in the cell. :blink:...

  • RE: Documenting Database Code: Structured Headers

    David Atkinson (7/8/2009)


    cameron.wells (6/30/2009)


    Where our massive improvements regarding database documentation have come from, is the use of extended properties. We now add extended properties for these following objects: Tables, Table...

  • RE: Music for DBAs

    "Hallelujah" - George Fredrick "I can" Handel "this"

    then

    Every Query

    FOR (unto us a_child is given); next;

    But who may abide the (slow indexing)

    The people that walked in darkness (have not read Joe's...

  • RE: The Independence Day Ruckus

    The British said, "The Americans are revolting." The rest of Europe said, "Agreed!" I feel sad that we only sing the first verse of that bloody awful song....

  • RE: MySQL Primer for the SQL Sever DBA

    Hi David.

    I never really had any problem with the MySQL engines themselves. If I stuck with myISAM I got single table backups and single table restores out of the...

  • RE: Automating tests for T-SQL code

    We are doing the same thing with Visual Studio Team Server. The Test Driven Development thing is being integrated into our methodology.

    Your tool looks to be a more affordable...

  • RE: Documenting Database Code: Structured Headers

    Great idea, Phil. By the way VB .Net has the XML comments too. They show up in the object browser. It forms the minimum set of documentation....

  • RE: Going Native

    Jeff Moden (6/23/2009)


    Heh... they also provide lots and lots of rope. 😛

    The better to hang oneself with my friend.

  • RE: Becoming a DBA

    I think that certifications are like the wizards. They can show you that someone can sit in class and take tests. They will do a good job of...

  • RE: Going Native

    Jeff:

    Puts me in mind of that old Dilbert strip where the boss says that they are going to pay heavy bonuses for every bug fixed. One of the developers...

Viewing 15 posts - 331 through 345 (of 820 total)