Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 6,041 total)

  • RE: Time for a ROWID?

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


    Eric M Russell (7/27/2011)


    The row id would have to be something both static and transferrable to the replicated instance, so it couldn't be a matter...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

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


    mtillman-921105 (7/27/2011)


    I like the way you think Steve, but you are much more informed than I am.

    Would a ROWID save us from those dastardly heaps?...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

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


    Eric M Russell (7/27/2011)


    I can see how the physical row id would be useful for debugging or performance tuning purposes, like perhaps identifying which table...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

    GilaMonster (7/27/2011)


    krowley (7/27/2011)


    Forgive a relative newbie to SQL internals but why can't the page size be variable per database or even per table? This would give the best of all...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

    bitbucket-25253 (7/27/2011)


    Steve is this what you are thinking of? (From Paul Randal's blog)

    http://www.sqlskills.com/blogs/paul/post/SQL-Server-2008-New-(undocumented)-physical-row-locator-function.aspx

    I can see how the physical row id would be useful for debugging or performance tuning purposes, like...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

    stephen.lear (7/27/2011)


    I think the reason you can't access the internal ID is that it can change when a reorganization takes place. So you'd break any integrity that relied on the...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Time for a ROWID?

    mar10br0 (7/27/2011)


    paul.knibbs (7/27/2011)


    I'm not sure increasing the row length in SQL would help much--after all, the largest data types are stored in off-row data pages anyway, and a properly normalised...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NewSQL Can Save the World

    cengland0 (7/26/2011)


    Steve Jones - SSC Editor (7/26/2011)


    That's so dependent on the indexing, the query structure in places, it's hard.

    I supposed you could set up the same hardware, same data set...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: How to add column in specific position

    Jeff Moden (7/25/2011)


    For all those balking about column order not mattering in a table, I absolutely agree when it comes to programming.

    But, for troubleshooting, it's sometimes very helpful and can...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Estimate Table size

    DIB IN (7/25/2011)


    How to estimate table size where row length is more than 8096?

    Clustered vs. Heap, fill factor, fragmentation, and several other factors may influence how the actual size of...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NewSQL Can Save the World

    cengland0 (7/26/2011)


    Revenant (7/26/2011)


    cengland0 (7/26/2011)


    Does anyone have a link to the performance differences for all the different database products out there? I heard a rumor that the MS SQL license...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: NewSQL Can Save the World

    Efficient relational database design is about constraints, normalization, and discrete data types. The problem faced by companies like FaceBook is not that their databases are large or that they have...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Leave Developers Alone

    Jo Pattyn (7/25/2011)


    Most people like to work from home/other room when they are interrupted too much or need a focus day, as most of the interruptions start with "Is person...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: guaranteed unique?

    If your intent is to generate unique integer values for use as a surrogate keys, then I'd reccomend IDENTITY over some function that returns a random number. An identity value...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • RE: Auditing a dynamic SQL UPDATE statement

    Chrissy321 (7/24/2011)


    Hello All,

    I have a requirement to build a user interface that will allow end users to generate and issue UPDATE statements. I am fairly certain I need dynamic SQL...

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 15 posts - 5,461 through 5,475 (of 6,041 total)