Forum Replies Created

Viewing 15 posts - 91 through 105 (of 341 total)

  • RE: Page Compression

    Bradley B (5/16/2011)


    Peter Trast (5/16/2011)


    Great Question and a lucky guess so I read up on it. The strangest statement in the msdn article I read (http://msdn.microsoft.com/en-us/library/cc280464.aspx) was:

    " If the space...

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

  • RE: Today's Random Word!

    Brandie Tarvin (5/16/2011)


    crookj (5/16/2011)


    Ray K (5/16/2011)


    WOTD: Rainy day and Monday

    "Always get me down...."

    GAH!

    Is that a word?

    No, just a horrible song... some 70's music is best forgotten. Hey, I liked Karen...

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

  • RE: Know Your SQL Objects

    Paul Randal (5/13/2011)


    Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...

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

  • RE: Page Compression

    Great Question and a lucky guess so I read up on it. The strangest statement in the msdn article I read (http://msdn.microsoft.com/en-us/library/cc280464.aspx) was:

    " If the space gained by page compression...

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

  • RE: Identity Crisis: Attack of the Clone

    Tom.Thomson (5/11/2011)


    WayneS (5/11/2011)


    Tom.Thomson (5/11/2011)


    Nice question.

    One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if...

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

  • RE: Today's Random Word!

    crookj (5/12/2011)


    Peter Trast (5/12/2011)


    Brandie Tarvin (5/12/2011)


    SQLRNNR (5/12/2011)


    crookj (5/12/2011)


    Ray K (5/12/2011)


    WOTD: ""

    (As you can see, I don't have much to say today . . . ;-))

    WOTD - Flashback (As in the...

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

  • RE: Today's Random Word!

    Brandie Tarvin (5/12/2011)


    SQLRNNR (5/12/2011)


    crookj (5/12/2011)


    Ray K (5/12/2011)


    WOTD: ""

    (As you can see, I don't have much to say today . . . ;-))

    WOTD - Flashback (As in the earlier posts about...

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

  • RE: Resource Governor Pools

    sanderstad (5/12/2011)


    I really like this feature which was introduced in SQL 2008.

    For my work I created a little Excel sheet I like to use to calculate these MIN and MAX...

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

  • RE: Resource Governor Pools

    Thanks for an easy one, my brain is tired this morning.

    Great question!

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

  • RE: Learn to Use Filegroups

    This is why I encourage so many people to take a class on SQL Server. As an instructor, I was always explaining feature sets to experienced veterans. I take my...

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

  • RE: Identity Crisis: Attack of the Clone

    Almost got it wrong until I remembered that IDENTITY does not have to be UNIQUE 🙂 I just WANT it to be... made me read carefully. That's why I think...

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

  • RE: The Poor Soul

    The job I had before my current one was a training position. I had zero technical training experience, but alot of hands on work and they thought my personality would...

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

  • RE: SQLServerCentral Best Practices Clinic: Part 2

    I have never seen or heard of a best practice for separating system and user objects, although your explanation sounds good on the first read. Is this your own best...

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

  • RE: SQLServerCentral Best Practices Clinic: Part 1

    I noticed when I first opened the tool that the INS1 page splits ratio to batch requests was running close to 20%, pushing the limits for my preferences, although it...

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

  • RE: Looking for Work in SQL Server

    sherifffruitfly (5/9/2011)


    Koen: Thanks for the pointers to relevant certs.

    I think one reason I haven't yet jumped into the cert game is that it appeared to me from the outside like...

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

Viewing 15 posts - 91 through 105 (of 341 total)