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. ...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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,...

    ATBCharles Kincaid

  • 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:...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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....

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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....

    ATBCharles Kincaid

  • 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.

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

  • 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...

    ATBCharles Kincaid

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