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

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

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

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

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

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

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

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

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

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

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

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

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

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

With Outlook 2007, I can create "Search Folders", which are sort of like views my inbox. If an email is addressed specifically to me, or specific team members are in...