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

Trey Staker (7/25/2011)

---

Speaking of superhero type movies, I rented "I am Number Four" this weekend and watched twice. I really enjoyed it, I rarely watch a movie more than...

And to get back to the water cooler...

Saw Captain America last night, and enjoyed it. The plot was a little rushed in places, and some of the action sequences were...

If you copy a file, and the copy fails, you still have the file. If you do a move in Windows, you potentially could lose the file or cause corruption....

I have awarded back all points to date for this.

I have also reworded the question to note that one batch is needed.

I have corrected the typo and rewritten the question a bit. I've awarded back points as well