Not close. Tagged, even an "ole", the runner doesn't hit...

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 or table partition a specific...

Roy Ernest (7/27/2011)

---

Change of topic, When will we know who won the Exceptional DBA of the Year Award? I just want to know if the Santa will be there this...

Ewald Cress (7/27/2011)

---

Eric M Russell (7/27/2011)

---

In addition to Microsoft retrofitting the storage engine itself, MSDN and the entire SQL Server community would have to retrofit all of our DMV and...

Perhaps, if it's in all structures.

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

Eric M Russell (7/27/2011)

---

It seems to me that there are performance advantages to having a smaller more granular page size, at least when querying non-clustered rows. If just one row...

The Dixie Flatline (7/27/2011)

---

Steve, maybe it's because I haven't had enough caffeine this morning, but I have a question: How does the ROWID column that you...

cengland0 (7/26/2011)

---

Thanks but that link does not appear to compare the database speeds. Sure it has a lot of computer configurations listed and you can click on a specific...

the Rockies have tanked, and are 9 games behind the central leading Pirates.

Going to see CIN-COL in Aug, not that it matters to either team.

The schedules are only for the re-use of the data, not for the execution. As Mr. Turner has noted, Jobs execute in parallel, or asynchronously of one another, regardless of...

Interesting. I'll see if we can come up with an article on this.

richardd (7/26/2011)

---

So a man who runs a company which sells a competitor to "oldSQL" products has given an interview saying the "oldSQL" is bad, and his "newSQL" competitor is doubleplusgood?

OK,...

I'm not sure that "nodes" was that confusing, but I've reworded it. I don't see a problem with the change.

David.Poole (7/25/2011)

---

If you accept the premise that your surrogate keys are going to be BIGINT values then you could try the following

The right most 6 characters are just a sequential...