:hehe:

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

Solomon Rutzky (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

I'm not saying there isn't a penalty for RBAR in T-SQL. Rather, I think it would be useful...

patrickmcginnis59 10839 (12/9/2013)

---

PHYData DBA (12/9/2013)

---

patrickmcginnis59 10839 (12/9/2013)

---

I'm not saying there isn't a penalty for RBAR in T-SQL. Rather, I think it would be useful to know why the penalty is...

patrickmcginnis59 10839 (12/9/2013)

---

I'm not saying there isn't a penalty for RBAR in T-SQL. Rather, I think it would be useful to know why the penalty is so drastic.

edit: fixed quote...

I think you are using words and phrases you do not understand. Cause you seem...

Solomon Rutzky (12/9/2013)

---

EDIT:

I would add that there is no parallel to cargo-cult societies given that it is scientifically provable that row-by-row processing is nearly always slower (within the realm of...

Jeff Moden (12/9/2013)

---

Consider a daily data file import, 60k rows. The data is loaded, of course, row by agonizing row, into a temp table. The mighty DBA, with his scimitar,...

Programing languages, each and everyone of them, to include PSQL and TSQL are abstraction layers. RDBMS are data storage systems. Agreed that RDBMS have an application and programing...

Nice question. Even more interesting name change of the question Author. Wonder what is causing that?! :w00t:

Didn't they call these the Ranking Functions in SQL server 2005?

It's a rhetorical...

jfogel (11/12/2013)

---

I got it right not because I actually knew the answer but because I figured that the data (meaning common) pages would be fixed by automatic page repair while...

Nice question Mike! I love these documented features that are documented in TechNet only copies of the Books Online. 😎

Rebuild all your indexes... That should create some memory pressure/data cache. :w00t:

Seriously though this can do well, but beware if you have high transaction volumes and are not using Enterprise...

SQLRNNR (11/1/2013)

---

I think something must have been somewhat screwed up with this question since the time some people answered it.

I see no actual question being asked. The code is...

+1 -...

scrrbiswas (10/28/2013)

---

This topic itself is nice and the techniques mentioned in this article can be used in many occasions.

However "change a dimension ID to see what happens" section does not...