I've been reading through the Sword Of Truth series for several months. Also, from these books the TV series Legend Of Seeker was adapted.

http://en.wikipedia.org/wiki/The_Sword_of_Truth

mar10br0 (7/28/2011)

---

For deduping duplicates in a heap-table, I would just delete all offending rows, then re-insert one record. Since a heap cannot have any foreign-keys pointing to it, this will...

Ninja's_RGR'us (7/28/2011)

---

I've actually had DTA CRUSH the server's CPU (large load) and then fill up the drive by growing...

The optional Power Pivot addin (reuquires Excel 2010) can analyze millions of rows. You don't need to import millions of rows into Excel to analyze the data using Excel. Rather...

Nadrek (7/28/2011)

---

It's the trivial case of "exclude each...

Nadrek (7/27/2011)

---

Eric M Russell (7/27/2011)

---

Nadrek (7/27/2011)

Actually, I'd very much like it to be exposed; for certain cases (say, overlapping date range detection), having an efficient, guaranteed unique per row value...

Nadrek (7/27/2011)

---

Eric M Russell (7/27/2011)

---

When a table is edited in SSMS, say to add a column or alter it's datatype, the operation will often times be scripted out in the...

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

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

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