Forum Replies Created

Viewing 15 posts - 121 through 135 (of 341 total)

  • RE: Running as SysAdmin

    I have a potential customer who wants to migrate his SQL 2000 environment from an "old" server to a new server keeping the SQL 2000 environment because of the custom...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Today's Random Word!

    Tom.Thomson (5/3/2011)


    Ray K (5/3/2011)


    Pachebel's Canon

    Cockney's drop their aitches, but what English dialect drops its ells?

    Estuary English - Ah want a gloss of miwk

    Often falsely identified as a type of cockney,...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Disaster Recovery Planning

    Oh I was tempted by the 4th choice thinking it might be a trick question 🙂

    Great question! I bet you would find disagreement inside many organizations...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Login Properties

    ...a-ha-ha-hand learning

    ...a-ha-ha-hand learning

    ...a-ha-ha-hand learning

    ...a-ha-ha-hand learning....

    Great question!

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Today's Random Word!

    Brandie Tarvin (5/2/2011)


    Peter Trast (5/2/2011)


    SQLRNNR (5/2/2011)


    83 as in SQLSat83

    86 (as in 86ing the old sql 2000 box...)

    Day is done,

    Gone the sun,

    From the lakes, from the hills, from the sky...

    And miles...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Today's Random Word!

    SQLRNNR (5/2/2011)


    83 as in SQLSat83

    86 (as in 86ing the old sql 2000 box...)

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Today's Random Word!

    Sober

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Normalization

    Tom.Thomson (4/29/2011)


    UMG Developer (4/29/2011)


    Duh, I was missing the obvious issue by paying more attention to the MAX portion. You are right, there would be no point in declaring it as...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Resource Governor Calculations

    cfradenburg (4/29/2011)


    Tom.Thomson (4/29/2011)


    Arrgh!! I see 36% got it wrong. I hope no-one feels too insulted by the above. But can it be true: 36% of SQLServerCentral subscribers are...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Normalization

    Tom.Thomson (4/28/2011)


    Peter Trast (4/27/2011)


    OK, here is the fix for hardcore 1NF fans. One column, long text datatype (pick your fav) like concatenating an entire name if there is no use...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Killing Statistics

    Lucky guess for me and a great question! Another interesting tidbit.

    A word of advice for everyone who is interested in these little morsels of SQL filler.

    Read the MCM reading list....

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Resource Governor Calculations

    Steve Jones - SSC Editor (4/28/2011)


    It's a fairly arbitrary concept and with conflicting information on the calculations, it's hard to understand what is correct. The way that it's given in...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Resource Governor Calculations

    Chris Umbaugh (4/28/2011)


    When attempting to learn the effective max% concept I read the following SQLServer Central article which I find misleading (at least as I interpreted it): http://www.sqlservercentral.com/articles/Resource+Governor/64034/

    It...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Normalization

    GSquared (4/27/2011)


    Peter Trast (4/27/2011)


    Steve Jones - SSC Editor (4/27/2011)


    I may be wrong, and I'll admit that. However the "use" of the data in terms of when/how you might call someone...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

  • RE: Normalization

    GSquared (4/27/2011)


    Richard Warr (4/27/2011)


    Nice question and an interesting example. Would renaming the columns "Telephone 1" and "Telephone 2" to "Home Phone" and "Mobile Phone" mean that the table was then...

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

Viewing 15 posts - 121 through 135 (of 341 total)